I am working on a scientific database that will store data and inventories of samples.
As of now I have a freeze sheet for every sample/vial I have frozen
I have a button on the freeze sheet that makes a inventory record from a concatenated field of:
Occasionally we thaw a sample. In the inventory there are the seperate Tank, rack, etc... fields, the concatenated field and other data. We want to keep the position data (tank, rack, etc...) filled in but the rest of the data we have being replaced with the word empty as it is thawed.
I need to ammend my script that creates a new record or goes to the related record from the freeze sheet to the frozen inventory. I would like it to recognize a concatenated field I have made for the freeze sheet and frozen inventory consisting just of the Tank, rack, level and position = F.I. unique field
Basically I want it to say:
If there is already a record in the inventory matching this F.I. unique field then
replace that record with the data from the record I am currently working on.
How would I script that?
I don't want to lose the data from the original freeze sheet that is why I chose to have two unique fields but I am not sure whether this will work.