Subform question using two tables

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
 
R

Ron2006

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

On the form that is showing the "units" change the value list to be
based on
"table/Query" and then press the "..." to the right of the next line
(where the field list is now) and create a query that selects these
units from your units table and perhaps add a sort.

Ron
 
R

Ron Weaver

Thanks Ron,
I had been trying to combine the tables in a query in the forms record
source.
This was too easy.
Thanks again.
Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top