Hi,

I am trying to create a form based on 3 tables that I have established links between.

I can obvioulsy import fields from one table but how can I bring in fields from the other 2? I've tried field listing but I'm only getting fields from the one table selectred when I created the form.

Any help would be appreciated.

Lewis

Create a query containing all three for your tables and then bind the form to the query.

When you need to access data in multiple tables its best to use MainForm/SubForm cobinations. If you just need to view the data a query will work. But if you need to add or edit data, then a multi-table query might not be updateable.

Can you explain this. I've never had trouble setting up forms this way. I prefer to access the table directly, but on occasion I do use multi-table queries for forms.

Thanks, I always learn something new from reading your posts.

The data is will need to readable and also allow me to enter data to it. I've not heard of main form/sub form, does this mean put each table on a seperate form?

William,
A query that contains multiple tables, especially in a one to many replation may not be editable, because Access can't know which record to edit. This article explains it.

FF,
Not on a separate form, but on a subform. Subforms are forms placed within another form that are bound to a different table. Look up subforms in Access help or check out the Northwinds sample for examples.