Use more than one table in Tabbed Form

[kully]

I have 3 tables which have one-to-many relationships. A Supplier table with general details. A Supplier Log table with meeting details and a Supplier booking table with any events we have booked with them.

I am trying to put these into one form where each tables data appears on a seperate tab.

I have tried doing a tabbed form, but cannot figure out how to combine the tables on a form. I can't do this from a query as I want to be able to update the data from this form.

Please help!

Thanks

 

[dynamictiger]

Have you considered using a mix of tabs and subforms.

You could set up a field on each tab that is populated with the SupplierID or similar and then create subforms that are linked to this field.