Abeetan
Member
- Local time
- Today, 14:30
- Joined
- Nov 30, 2021
- Messages
- 39
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.
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.