I have a datbase that has 1200+ records. I exported all the records with the FileMaker 7 extension.

My problem is I do not need all the records back in the database. I only need ones that the item has not been sold. The boss only wants those items back in the database.

Can I script to have this done? If so, how? I know how to import but not with this condition.

Again, I only need the records out of the 1200+ that the item has not been sold to import back into the new database. Thank you.

"My problem is I do not need all the records back in the database. I only need ones that the item has not been sold. The boss only wants those items back in the database."

There's alot of ways to filter out a database. Based on the info you've given is very vague. If each record has an identifier that tells the item is sold or not, then basically what you can do is find that are not sold then export it out to a Filemaker database.

Hi,

Similarly to the post by Andrew, you can either:

1. Export only those records which are not sold. You achieve this by first doing a Find to isolate these records, and then performing an export.

2. Or, if you only have the option of importing now, you can import all the records, and then once all the records are in a FM file, you can do a search for sold records, and delete your found set of records.

Cheers,

jd.

Edited January 10, 200620 yr by Guest