Jump to content
Sign in to follow this  
Heathbo

A record file & a browsing file

Recommended Posts

Here is what I'm trying to do. I have a FileMaker file(A) with over 800 records in it. I want to create another FileMaker file(;) that will browse the first file. That way I can make updates without requiring the end user to re-import their entire database. My question is. Is there a way to browse all the records in File(A) through one record in File(:). Otherwise I would have to run a script that creates a new record in File (B) for every record in File (A) and then import the keys from File (A). Is there a better way of doing this? Am I going about this all wrong? Any help you can give is much appreciated.

Share this post


Link to post
Share on other sites

I figured it out. File(;) browses based on File(A) record sequence number.

Share this post


Link to post
Share on other sites

You don't need to "browse all records ... through one record." If you create a File Reference in File B, and then build a Relationship graph in B based on the data tables in A, then you'll be able to view, edit, etc. all the records in A.

It's called the Separation Model ; you should check out the Separation Model Forum here. That design method is specifically designed to provide User Interface access in one file, and Data Storage in another.

HTH,

David

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.