Search results

Correct -- those are multivalued fields.

See attached image. This is what I wanted to accomplish. So when a list of activities gets filled out per person, there is a description for each code, so its clear that "D3" is "main engine driver", but once the form is filled out, all thats left per row are codes like D3 and M77 -- and who...

Follow up question..... If all the attributes of a product are to show up among details on the invoice, does that mean that these attributes should have been included in the details table schema? The fact that ProductID was included in the Details schema is not enough?

This is my first access project..... Lets say I have the typical invoice project. There is the invoice table and form, and in the middle of it, there are multiple rows from the details table that list the products that make up this invoice. So far, I got that part worked out. All the tutorials...

This is awesome -- will give it a try. Thanks a lot

Thank you for the response, but I am literally looking for how to computerize an existing business. They currently have one page paper forms with code legend at the bottom, so I am trying to mimick what they already have. Didnt realize something this conceptually simple is so complicated

Imagine a medical form or a motor vehicle dept. form -- at the bottom, there are multiple codes. I have stored these codes in a table. What I want is to display all of these codes at the bottom of my form -- top to bottom, and then left to right "flowing over" into the next column...