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

[Guest]

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

 

[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.

 

[Guest]

Thanks for your input, I'm "new" to Access and appreciate any help! Will work

 

[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.

 

[John Vinson]

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

As Allen says... you don't. That's not how relational databases work!

Check out the links at

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

for some tutorials on how to get into the relational mindset. It can
be a steep learning curve but you'll find it very powerful when you
get into it!

John W. Vinson[MVP]