Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

update two tables with one form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Christina - 17 May 2007 16:41 GMT
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
RBear3 - 17 May 2007 16:54 GMT
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.

Signature

Hope that helps!

RBear3
.

> Hi,
>
[quoted text clipped - 5 lines]
>
> Christina
Amy Blankenship - 17 May 2007 16:54 GMT
> 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?

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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.