Using Form to populate several tables

K

Kevin G

I want to create a form to track orders, however, the data that a user will
type in for an order is also on 2 other tables that contain more information.
Is there anyway to update that information as well?

Example of what I'm trying to say:

Table: Orders - Field: Circuit ID

I'd like to update the Circuit ID field in both Table: Entrance and Table:
DS3 without the user having to do too much.

Is that possible?
 
K

KARL DEWEY

What about setting up one-to-many relationship with cascade upde related
fields and use form/subforms for data entry and viewing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
How to have two tables on same line? 1
Adding data to MS Access from csv file 0
Populate junction table 12
Populate a table based on check box status 2
Dynamic Naming of Form Button 3
Pause VB Code 1
Appending tables 0

Top