My problem is I can only get some fields to update by an extra click on the page.

Data structure is.

Tables Patients (one to many) Episodes (ONe to One) Organisation

I am on a Patients layout and using a drop down list to pick Organisation.

EG PAT::pk = EPP::pat_PK to get to the episode

EPP::ORG_fk set from a drop down list where EPP::typeORG = ORG::typeORG

Sets the fk fine but wont update ORG::Name on the patient layout without an extra click.

I have tried messing with script triggers and read some stuff about using portals and overcomming the problem of two layers of relationships.

I hope I have explained clearly.

Thanks

J

JUst to clarify

I can use Refresh WIndow but that gives a window flash. I was hopeing for something a bit more elegant.

J

Commit the record?