Jump to content

Relationships in FileMaker 5.5


Kaiden
 Share

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

Recommended Posts

I hope you guys can help me with this. I have two databases, one is the master and the other is an archive database. I need to pull information from the archive database into the master database, however I am working in FileMaker 5.5 I know it is a pretty old system but this is what I am working with. What is the easiest way to link these two databases together?

Link to comment
Share on other sites

If the two files contain the same type of data, it's generally much easier to manage if all the records are in one file. You can use a Status field to distinguish between those that are Active and those that are not, and have your Finds and relationships filtered by that Status.

The possible reason you might use archiving to another file is in FM5/6 when you start having performance problems due to the number of records. This seems to happen around the 200,000-300,000 record mark. But in this case, I'd recommend either purging the records that have been inactive for more than a year (or whatever), or upgrading to FM8.5 so that file size and record count won't be an issue.

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 5755 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
 Share

×
×
  • Create New...

Important Information

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