Form using more than one table?????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 with the tabels/fields you need for your form.
creat a form with the wizard with the query

suc6

Nne
 
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
Click to expand...

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
 
Most of my forms are based on a single table. Related, child records are
displayed in subforms on the main form.
 
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
 
I have no idea what you are storing or why you have 4 different tables with
4 forms.
 
Back
Top