April 28, 200520 yr Newbies 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!
April 28, 200520 yr 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.
Create an account or sign in to comment