Jump to content

Relational DBs - How can you "unrelate" one?

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

Recommended Posts

  • Newbies

Help! Please! I'm relatively new to FilePro 5.5, and kinda under the gun with a very big project. I was thrown into this position with no training, and no one in the office is able to help! I have a master db (I think), and another related one that I would like to remain "static", for lack of a better word (not quite awake yet). I need to input the data in the related db and have it come up in the master db; the way it is now, as soon as I enter a number in the master to pull up the data from the related, it changes everything around in the related and doesn't come up properly in the master.

I am in dire need of assistance!

Link to post
Share on other sites

Relationships between files are driven by 'key fields'. When data is entered into the key field in your main database, any records which have matching data in the corresponding key field in the related file will then be located and displayed in related fields (in a portal or directly placed on a layout) in the main file.

If you are not seeing the data you expect to see, then the first thing to look at is what is in the key fields. To find out what the key fields are, you can view the relationship definition by going into the "Define Relationships..." dialog from the File menu.

Assuming the relationship is set up correctly - and the two key fields are of the same data/result type (something you can check in the 'Define Fields...' dialog), then the problem most likely lies with the data itself (ie key fields hold wrong keys or ID numbers or whatever).

Link to post
Share on other sites

This topic is 6564 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.