We are migrating our database from FMP to some RoR environment (pfff...) and I need to tick off the contents of 30 Fields against each record.
- Is company name correct?
- Is Number of products identical to the list in the legacy DB?,
- Is Product Category correct and so on)
What is the best / most efficient way to do this in FMP: Do I create a new Table & Layout with separate Fields for each Question/TickBox, or design a new Layout based on an existing Table that has most of the Fields we need to compare and create just one new Field for the TickBox?