Hi, I am fairly new to filemaker and I am wondering how to go about solving an issue: I need to inventory samples and produce a report that shows which samples were pulled (discontinued), which samples were missing and finally a listing of samples that were present. There are upwards of 1,000 samples.
Would it be better to copy the records from the lookup table (contains a list of all the samples and whether they have been discontinued or not) to the Sample table and then simply mark a field for each sample whether it was pulled, missing or present?
Another option I think would be to add a "status" field to the lookup table. This field would be set to null for each record in the table prior to taking inventory. I would then need to create a report showing the results. The downside of this technique would be that I would only have a report to show the results, not a record.
Any suggestions or advice would be aprreciated.