MikeTheDataGuy

I'm having problems finding any topics on finding and removing duplicates without deleting the original record in FMP9. Can anyone copy and paste instructions? Thanks Mike

How do you do that advance search that you mentioned. I'm trying to delete all dups from the database without deleting the originals.

Hi. If I use ! in the Find Mode, will this find all of the duplicate records in my table? If so, can I delete the "found" duplicate records in order to have a clean, no duplicate database? Thanks

I only have 1 layout selected .. the name of it is db. There are no other layouts. That's why this is confusing for me. Any other tips? Ideas?

Hi, I'm new here but I hope to learn a lot of FMP 9.0. I'm a tech guy for a local company and we've just acquired a massive database of around 10 million records. The file size in raw data is around 10GB, so it's pretty huge. I'm very familiar with MS SQL and MS Access BUT Access can only hold up to 2GB file sizes, so I had no choice but to go for FMP 9.0 since there's no file size limit. I tested a database of around 31,000 records by simply creating a table, importing the CSV file into the table (matching the field names, etc). It imports correctly BUT I cannot see the actual data (information). On the left side of my table it states: Total 31625. I can click on the "notebook" picture to goto the previous record, next record etc BUT nothing appears on the main screen. No fields, no text, just blank white page. Attached JPG is the screen shot. I clicked on Browse mode, form mode, all types of modes, View as list...etc What's wrong? Thanks Mike