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???

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.

Hey! I'm having the same problem now.  What should I do to resolve it?  I'm not good at this, I hope you can help me.  Thanks!