Jump to content
Sign in to follow this  

importing found sets

Recommended Posts


In FMP6 if I imported from another file, it would import the current found set. How can I do that in FMP7?.

What I really need to do is this:

I have a job table and a line item table consisting of what we call Descriptors. Each descriptor has line items also. So the descriptors are pulled from a descriptor table which also has a line item table.

I need to create a Bill of Materials for the Job that consist of the line items in the Descriptor line item table. I want to store these in its own table called BOM. Does any of this make sense.

I was going to pull up the line items from the descriptors one at a time and import them into the BOM table but I can't import the set it take them all. If there is a better way to do this I am open and desperate. Or can I import the set somehow.

Thank you so much if you have read this far and any help would be greatly appreciated.


Share this post

Link to post
Share on other sites

Update to v3. It fixes the issue of importing a whole table instead of the found set.

Share this post

Link to post
Share on other sites

The file you're importing FROM has to be OPEN, perhaps even on the relevant table (haven't check this), with the found set.

FileMaker will import ALL records if the file is closed.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.