hi i hope you are well.
i have a customer with a file maker pro 11 database.
it has a 9gb datafile spanning 10 years of records.
i want to trim this down to the last, say, 2 years to make the whole thing easier to backup
i cant see how to do this. i have zero experience with filemaker so excuse me if this is a n00b question. i did about 2.5 yrs of sql 10 years ago though...so ive some idea of how databases operate.
ive made a copy of the database for archive purposes, and now want to remove all the records except for the last 2 years from the live database. (or i can do it the other way round, or some other way if anybody has a better suggestion)
any idea as to how i can do this please? bear in mind i have NEVER seen filemaker before.