Creating New Record in Form with multiple tables

[angelmorrison08]

I'm trying to create a form that will pull information from multiple tables
for data entry updates. I know how to create subforms for this, however I'm
having trouble creating new records from this form. I want the primary keys
to be AutoNumber so the users doesnt have to enter this number in multiple
times. Is there a way to ensure the forms stay in sync when a new record is
created? If this is not the right way to do this, please let me know-getting
frustrated! Thank you!

 

[KARL DEWEY]

If your tables have a one-to-many relationship set with Referential
Integerity and Cascade Update related Fields then using a form/subform with
Master/Child links on the primary key/foreign key will automatically insert
the foreign key for each new record in the many side table.

 

[Rob M.]

I think what your asking Angel is if the data you are entering will be
updated to the tables via a subform or form, and I'm going to suggest you are
probably thinking about putting a combo box to look up data so you don't have
to retype.

The answer would be that the data from a form would update, but be careful
if you use an option box, I had a problem where one of the rows was not
updated from my form and I don't know hy exaclty, except that it was a
recordsource for a text box. I think that's where you have to be careful.
The recordsource property using the same row on the same form. i.e Options
:asset,liability,equity......I used choose and then stroed that value in
txtAcctType. The txtAcctType value does not appear in my table. In other
words "asset", "liability", equity" which is stored in txtAcctType does not
update the table tblChartOfAccts.

Try the combo box.

Rob M