Form using more than one table?????

[teelee]

Can I create a form with more than one table. I have several tables and I'm
not sure how I eould create a form using all tables.



Thanks

 

[nanne]

create a query with the tabels/fields you need for your form.
creat a form with the wizard with the query

suc6

Nne

 

[fredg]

Can I create a form with more than one table. I have several tables and I'm
not sure how I eould create a form using all tables.

Thanks

Create a query using your tables.
Make sure all of your table relationships are correct.
Make the query the form's record source.

Note: Not all queries are updateable, so you may not be able to add or
change data.

See Access help:
Query + Troubleshoot queries + Select Query + I can't update data
from a query + Data can't be updated

 

[Duane Hookom]

Most of my forms are based on a single table. Related, child records are
displayed in subforms on the main form.

 

[teelee]

So if I made 4 different tables w/4 different forms this will work out ok?
The way I have it now is after data is entered into the last field on the
first form I have it going to the next form. The only problem I'm running
into is with the records, they are not cycle in all the forms.

Thanks

 

[Duane Hookom]

I have no idea what you are storing or why you have 4 different tables with
4 forms.