I need advice or ideas on how to resolve a design issue that has come to light.
I have the table
tblSeabrookcompany
SeabrookCompanyID - Primary Key
Company - Text Field
I have the related Table (Limited to relevant fields)
tblGITClaims
ClaimsGITID - Primary Key
SeabrookCompanyID - Foreign Key
So a relationship has been established between the Primary Key and Foreign Key.
I now need to edit the Foreign Key in tblGITClaims.
The FK is a number passed only through openArgs in an unrelated form.
I'm scratching my head as to how to do this, any ideas?
Regards