How to permanently link two records in different tables?

I have a table USER, COMPANY and OFFER.
If I create a record in the OFFER table, the company name from the COMPANY table is written to it. If I change the company name in the COMPANY table, the record from the OFFER table is detached. That is, there will be no relationship because the name has changed.
How to solve this situation?

Add a RowID column to your Company table, and use that as a CompanyID.
Then instead of adding the Company name to your Offers table, add the CompanyID, and use that to make the relation. If you subsequently need the Company Name in your Offers table, you can use a lookup through the relation.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.