redridinghood
New member
- Local time
- Today, 07:14
- Joined
- Jul 13, 2018
- Messages
- 7
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 show that the details table would include a lookup link to the ProductID, Description -- good so far, got it working.
Here is what I dont understand -- lets say the products table contains ProductID, Description, Country of Origin, Color, Size, etc. If all of these are to show up on the invoice and all of these attributes are separate columns on the invoice, does the Details table have to include a lookup link for each attribute? So if the Details table contains lookup for ProductID and 5 of product attributes, thats a lookup for each attribute? Is that how it works or am I missing something?
I would like to think that a record lookup for a product occurs just once, and then each piece of record data retrieved would get stuffed into different columns of my details subform.
Thank you, folks
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 show that the details table would include a lookup link to the ProductID, Description -- good so far, got it working.
Here is what I dont understand -- lets say the products table contains ProductID, Description, Country of Origin, Color, Size, etc. If all of these are to show up on the invoice and all of these attributes are separate columns on the invoice, does the Details table have to include a lookup link for each attribute? So if the Details table contains lookup for ProductID and 5 of product attributes, thats a lookup for each attribute? Is that how it works or am I missing something?
I would like to think that a record lookup for a product occurs just once, and then each piece of record data retrieved would get stuffed into different columns of my details subform.
Thank you, folks