Newbies Change Posted April 8, 2007 Newbies Posted April 8, 2007 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now