Table 1
Freeze date = Date/Time
Pouches on Date = Number
Pouch Number = Number
Strain = Text
Quanta Results = Hyperlink
pH = Number
Clot Result = Text
Frozen by = Text
Date used = Date/Time
Notes = Text
Sample Code = Auto Number Primary Key
The sample code is used to identify the pouch, I used it because it gives the next available number and can not be duplicated. When a pouch is pulled after several months, we need to be able to retrieve that record and enter a Date used. Thats why I need to search by sample code. If I can create a field called Sample Search and have it look for the entered Sample Code referencing the sample code column, that would be great.
Any ideas?
Thanks