I have a table with unique parcel ids and acreage, and another "master" table with other property information. I want to be able to link the child parcel records to the master property record card via a layout and have them listed. I used to enter a parcel id via a portal which would create a new record every time, but now I have a complete table of parcels with their acreage and want to be able to just select them and update their fk to have them associated.
How could I best go about this? Would there be a way to enter the parcel number, check to see if it exists/is already associated, and then just update the fk based on the current record?