Navigation buttons not bound to correct table

[TomAccessNewbie]

I have two tables (Order and Item) that have a one-to-many relationship in my
Order form. The form consists of two tabs, one for Order fields and one for
the Item datasheet. The default Navigation buttons on the Order tab is bound
to the Item subform on the Item tab rather than Order. How can I re-bind the
default Navigation buttons on the Order tab to Order rather than Item? Item
has its own built-in Navigation buttons.

 

[Jeanette Cunningham]

Tom,
Start over again with a new form using the form wizard.
With the wizard use both tables and select all the fields from both tables.
Choose the default option of form with subform.
You will get a form for orders with a subform for items.
Save the form.

Open the form in design view and delete the subform from the Order form.
Use the toolbox to put a tab control on the form.
Put all the fields from the Order form on the first page of the tab control.
On the second page of the tab control, use the toolbox to place a subform
control and put in it the item subform.
This should give you separate nav buttons for orders and items.

There is a potential problem with your table setup - Any order can have many
items, this is one to many.
However it is likely that the same item can be on many different orders.
Depending on what your business need is and what data you are wanting track,
this may be a problem for you.

You might have a many to many situation and you might want to use a third
table with OrderID and ItemID and call it Purchases
There would be a one to many relationship between Orders and Purchases
There would be a one to many relationship between Items and Purchases.

Jeanette Cunnningham