Enter data in one and have another field update automatically - Data Entry Form

[Abeetan]

Hello

I have two tables that are linked with a field called the "Purchase Order Number" (one-to-one Relationship). In one table, I have certain fields that describe the purchase order number and I have another table that has more fields that describe the purchase order number. Obviously, this was done due to the normalization of the tables.

Now here is what I am trying to achieve. I want to be Enter the purchase order number when the order is created (the record) and at the same time, I would like to create a record in the second table with the same order number automatically. How can I do that?

Please advise

TLDR: I want the purchase order number in a field in table 1 and have another field from table 2 update automatically at the same time in the same form.

 

[jdraw]

Obviously, this was done due to the normalization of the tables.

Could you please tell us more about your application and tables? 1 to 1 relationships are not all that common.

 

[oleronesoftwares]

I want the purchase order number in a field in table 1 and have another field from table 2 update automatically at the same time in the same form

Do send in images of the forms and tables.

You will likely use a combo box(to look up the fields) and place the code on the after update event to automatically enter a value in another field in same form

 

[Abeetan]

Do send in images of the forms and tables.

You will likely use a combo box(to look up the fields) and place the code on the after update event to automatically enter a value in another field in same form

How can I do that?

 

[Abeetan]

 

[oleronesoftwares]

How can I do that?

in VBA On the after update event of tbloutgoingpo.purchaseorder

enter the following
me.tblarchivePO.purchaseordernumber=me.tbloutgoingpo.purchaseorder