update two tables with one form

C

Christina

Hi,

I am creating a new database and ideally would like one form only to enter
the relevant data, but that means it has to update two or more tables from
that. Is that possible?

Thanks

Christina
 
R

RBear3

Yes, but you need to explain your data structure a bit. In a relational
database, you can have several different types of relationships.

What does your form do? If you have a form that adds customers, then it
would probably just update one table. If you then want to add products to
your database, that would probably be a separate form.

Now, when it comes time to sell a product, you would most likely open a form
where your invoice data was on the main form (and creates a record in your
invoice table) and your items sold on that invoice are part of a subform
(which creates other records in your invoice details table).

In order to answer your question, we'd need to know exactly what you are
doing and the structure of your tables.
 
A

Amy Blankenship

Christina said:
Hi,

I am creating a new database and ideally would like one form only to enter
the relevant data, but that means it has to update two or more tables from
that. Is that possible?
Click to expand...

Depending on how the tables are related, probably. You can try to create an
updatable query and work from that, or you can use a form with a subform,
which can be edited so that it is not apparent that the subform is not just
one more part of the form.

HTH;

Amy
 
Top