Hi,
I know I have a lot to learn before I am close to ready to actually do my project, but I started creating a few tables just as practice and because I learn by doing.
Here is the issue....
Created tables below:
Instrument Category (this tells the different categories of instruments)
Category
Departments
Department
Instruments
Instrument Name
Qty
Category
Department
Now I want an "assembly table" to create an assembly of instruments into a set......Here is the problem- How do you create a table that will allow you to enter say - (6) Instrument A, (8) Instrument B, (2) Instrument C, etc...?
Set
Instrument Name
Qty
If you can help me understand how to do this it will push me way down the road!
Thank You in advance for your time,
Kevin