How do I allow multiple choices from table to be entered in colum

J

JC

I have multiple codes (choices) available for selection in one column; how do
I allow (show) the information in table view?
 
A

Allen Browne

You must create a related table to handle the many choices.

This concept of the one-to-many relationship is the core idea to grasp in
designing relational databases.
 
A

Allen Browne

For an example, open the Northwind sample database that comes with Access.
Then open the Relationships window (Tools menu) to see how the tables fit
together.

An interesting example is the Orders and Order Details tables. One order can
have many line items, so the lines for the order are in the Order Details
table.
 
J

John Vinson

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top