G
Guest
I have multiple codes (choices) available for selection in one column; how do
I allow (show) the information in table view?
I allow (show) the information in table view?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
This concept of the one-to-many relationship is the core idea to grasp in
designing relational databases.
G
Guest
Thanks for your input, I'm "new" to Access and appreciate any help! Will work
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.
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
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]