Jump to content

Relationships do not immediately relate problem


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

Recommended Posts

Posted

Hey guys

 

I am having a very wierd problem.

 

I am on FM Server 12 with FM Pro Adv client.

 

I build a record in "Company" and give Company a unique key, say Company.Key

 

I then build a record in "Phone" and give Phone the Company.Key

 

So.  Company::Company.Key = Phone::Company.Key

 

The tables WILL NOT relate until after I go in and change something on the database.

 

So, say I am on the company form with a portal to phone.  After I build the records, the portal is blank.

 

I go in to the database, change something, save, come back to the company form, and voila, the portal is now populated.  No amount of clicking around, committing, or anything else, seems to create the relationship unless I go in and do something to the database.

 

Ideas???

Posted

SOLVED.

 

I did not understand Commit properly. I thought Commit committed all records in all open windows.

 

What I am doing is creating a new window for phone, creating the record, and then selecting back to the company window leaving the separate phone window open (but uncommitted).

 

I was then executing commit while the company window was selected.

 

I now execute commit while on the phone window before selecting back to the company window.

 

Problem solved.

  • 4 weeks later...

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