Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6498 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Have split Database A and B into two master files and two data files ie, “A Master”, “A Data”, “B Master”, “B Data”. Master files have only Layouts and scripts and no tables while data files have only one table each and nothing else. Master files use the data files for their data. The files were converted from the days of only one table per DB and it's too hard to join all master files into one.

Relationship A to B is one to many. Prior to splitting the two, I had “Go to related record” scripts getting me between the two databases. These no longer work because when I’m in A Master I am related to B data and from B Master I am related to A Data but A Master and B Master can’t relate to each other because they don’t have data. Does anyone know what I can use in place of “Go to related record”?

My only work around so far has been to pass Record ID script parameters from the calling database and perform a find in the receiving database. Not the cleanest method and it destroys any found set I had previously.

This topic is 6498 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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