Models need help!

[ace_bird_dog]

OK, I thought I had this whole relationship thing down but then I ran into this and can't figure it out.

I have two files - "Models" and "Agencies". I want to be able to assign agencies to models in the Model database using a value list of agencies from the Agencies file. I have serial ID's setup in the Agencies database so each record has a unique key. I'm fine up to this point, but this is where it gets tricky. I want the data about the agencies to update automaticaly in the Models database when a change is made in order to not orphan records. Currently if I make a change to the agency name, the value list updates but the existing content of the field does not.

The models are pleading for help!

[NYPoke]

What is is in the "existing content" field?

In the Layouts of your Models file, all data from Agencies should be referenced through a Relationship.

The fields on the Models Layouts should look like AgencyRel::Agency Name, AgencyRel::Agency Phone Number where AgencyRel is the Relationship based on AgencyID and Agency Name & Agency Phone Number are fields in Agency.

You should not have any Agency information stored in Models. Only problem I can think of, is that you might need to call a Refresh Window step.

If you DO have some Look Up fields in Models, based on Agency, you can perform a Relookup Contents script step, to refresh the data.