Forms: using two tables and a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a curious situation. A form can only be linked to one table. How can I
view and update from one form into two tables?

Here are the details.

I have a form. The form is meant to compare let's say two orders, for the
same customer on the same day. There are always two orders to the customers,
each day. One order belongs to Morning Group and the other to the Afternoon
Group. With the orders, there is enough data that it will not fit on a single
table. Therefore, there are two tables, Morning Group Table and Afternoon
Group Table. The condition is that I have to use one form to compare each
customer's morning and afternoon orders each day.

In this form orders are compared side by side. The morning orders never
change. It is the afternoon orders that need an adjustment.

This is what I am trying to accomplish.

1) I need to pull data from both tables into that one form.
2) In the form, data from one table will by view only.
3) In that same form, data from the other table needs to be updated.
4) Records are toggled using the customers name via combo box, the tables
are linked 1to1 via the customer's name.

A form can only be linked to one table. How can I view and update from one
form into two tables?

Any ideas???
 
Have you tried using a main form with a combo box to select a
customers name. Then have two subforms based on the two tables. Link
both subforms via the customers name.
 
Thanks Peguin, that worked just fine. I just had to create some extra forms
unique to the fields. it worked well.

Cheers!
 
Back
Top