...Into an Access Database. For example, X company purchases products from the G10, S20, S35, S40, S30, O50, AND O70 product groups. Is there a way to incorporate this extra information into a the database?
thanx in advanced!
thanx in advanced!
How to incorporate customers that buy from more than one product group into an Access
- Thread starter armrodnun
- Start date
HiTechCoach
Well-known member
- Local time
- Today, 06:22
- Joined
- Mar 6, 2006
- Messages
- 4,353
Without seeing the table structures is is hard to know for sure.
I would assume that you have a "product list" table. To this table you would add a way to track with group or groups a product is a part of. If a product can only be in one group, simple add a field. If a product can be in multiple groups,you will need a child table (one to many relationships) .Then you can create a query to get what you want.
I would assume that you have a "product list" table. To this table you would add a way to track with group or groups a product is a part of. If a product can only be in one group, simple add a field. If a product can be in multiple groups,you will need a child table (one to many relationships) .Then you can create a query to get what you want.
Similar threads
