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

Update Two Tables Using One Form Contents 0
Populate junction table 12
Using form and subform not connecting to two separate tables 0
Order entry form using data from a second table 5
Auto Populate Fields on a Data Load Form 2
Separate Form 0
Problem with multiplying value of two fields from different tables 4
Search by Keywords 3

Top