Using Form to populate several tables

  • Thread starter Thread starter Kevin G
  • Start date Start date
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?
 
What about setting up one-to-many relationship with cascade upde related
fields and use form/subforms for data entry and viewing?
 
Back
Top