I have 3 tables (each has an auto number for PK) as follows:
Job table - holds a job # that auto-increments by 1 (not PK) and job name Ect.
Item table - (related to job tbl by FK) misc details about each item on the job.
Acc Table - (related to item tbl by FK) misc details for accessories added to the items.
Every order has at least one item.
But there is not an accessory for every item, some items have acc and some do not. I can make a combo box that holds each job but then I want to create a combo box that lists all items AND their accessories in the list as if an accessory was an item in the list, the same as the items.
so my list would look like this.
first combo box would just list the jobs
second combo box would list items and accessories
Item1
Item2
Item2-1
Item2-2
Item3
Item4
Item5
Item5-1
Item5-2
Item5-3
Ect....
Any help would be appreciated.
thanks
Job table - holds a job # that auto-increments by 1 (not PK) and job name Ect.
Item table - (related to job tbl by FK) misc details about each item on the job.
Acc Table - (related to item tbl by FK) misc details for accessories added to the items.
Every order has at least one item.
But there is not an accessory for every item, some items have acc and some do not. I can make a combo box that holds each job but then I want to create a combo box that lists all items AND their accessories in the list as if an accessory was an item in the list, the same as the items.
so my list would look like this.
first combo box would just list the jobs
second combo box would list items and accessories
Item1
Item2
Item2-1
Item2-2
Item3
Item4
Item5
Item5-1
Item5-2
Item5-3
Ect....
Any help would be appreciated.
thanks