AnsweredAssumed Answered

Table to table copying or another technique?

Question asked by woodeye on Dec 27, 2012
Latest reply on Dec 29, 2014 by StephenWonfor

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.

 

Thanks,

 

john

Outcomes