1 form for multiple tables

[gmc5135]

Hello all,
I've very new to Access and need some serious help, or at least a nudge in the right direction. Attatched is my database. I would like to have one form that can enter all the information in the database. Not sure if it matters or not, but eventually I would like to have buttons to make reports for this information too. I've seen some tabbed forms, but I'm not sure if this is the right way to go or not. What do you think is my best bet? Thanks for the Help!

 

[John Big Booty]

A form can only be bound to only one Table.

However if you have an unbound form you could use an Append Query to any number of tables.

 

[Pat Hartman]

Forms shouldn't be bound to tables at all. They should be bound to queries so you can limit the records selected. Once you bind a form to a query, it is bound to all the tables in the query. That doesn't mean that you should attempt to use a single form to update data. Normally, you would use forms with subforms so that data isn't "duplicated" and the only time a query includes multiple tables is if they are lookup tables. So a form that shows Order information would be bound to a query that joins the order table with the customer table so that customer information can be easily displayed. Then the Order form would have a subform that displays the items ordered.

 

[gmc5135]

Thank you both very much!