Form for entering data in 3 tables

M

Marco Simone

Hi,

I would like to have form in which I can enter data in 3 tables. So, in this
form would be text boxes for entering data in 3 tables.
Is it possible to do this without subforms? Do you have some guidance where
to learn this? I suppose I would have to use VBA.

Thanks for your reply, Marco
 
A

Adam

Use a query to bring all three tables together.

Make sure all relationships are one-to-one OR one-to-many.
If there are many-to-many records, you'll need a junction
table to be able to 'add' records to those underlying
tables.

When saving the query, use a name that will be
distinct...such as "qryAllthreetables", so that it is
obvious in your VB code that you are dealing with a query
not a table.

The form's source of data should be the query...not the
tables themselves

Regards

Adam
 

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

Similar Threads

Update Two Tables Using One Form Contents 0
Entering data in forms 2
Entering data in one form while updates 2 or more tables 4
data entry form based on more than 3 tables? 1
data entry form for several tables 2
forms with data from multiple tables 4
Form - Two tables 4
Form to Multiple Tables Issues 3

Top