Adding Large Amounts of Data
I am running FMP-9 on an iMac (with Snow Leopard).
In my database, I have over 70,000 records. They all relate to dates in history (each record is a specific event in history). In a careless oversight, I realized that I did not allow for dates occurring before the modern era (eg., BC or BCE). A simple fix would be to add either "BC" or "AD" to each record. Is there a quick way to add this information without updating each record individually?
Or, does someone have a better, more efficient solution? I am open to all suggestions?
Thank you in advance,