Jump to content
Sign in to follow this  
SandraDawn23

Relational DBs - How can you "unrelate" one?

Recommended Posts

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!

Share this post


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).

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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