R
Ron Weaver
I have an Orders form that has three subforms based on many to many tables.
One of the subforms takes an order for food and beverages to be used in a
meeting. With this subform you can order a variety of items
(Coffee,Doughnuts, Orange Juice, etc.), with the quantity needed for each.
This order form and the three subforms are working perfectly. Well, I have
decided that I want to add another field to the Food and Beverages subform.
This field 'Units', will be a combo box with a choice of units: Ea, Doz, Pt,
Qt, Gal, etc. At this time I am using a Value List which works fine, but I
would like to add a table to make it easier for the user to add to, or edit
these units. I have created a 'Units' table and a junction table to go with
it, but I'm having trouble getting it to work in the Food and Beverages
subform. If this can be done, can someone help me with the relationships or
give me some other ideas?
Thanks
One of the subforms takes an order for food and beverages to be used in a
meeting. With this subform you can order a variety of items
(Coffee,Doughnuts, Orange Juice, etc.), with the quantity needed for each.
This order form and the three subforms are working perfectly. Well, I have
decided that I want to add another field to the Food and Beverages subform.
This field 'Units', will be a combo box with a choice of units: Ea, Doz, Pt,
Qt, Gal, etc. At this time I am using a Value List which works fine, but I
would like to add a table to make it easier for the user to add to, or edit
these units. I have created a 'Units' table and a junction table to go with
it, but I'm having trouble getting it to work in the Food and Beverages
subform. If this can be done, can someone help me with the relationships or
give me some other ideas?
Thanks