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!

Thanks for the rapid response. This is related to my other post you just responded to. The files are attached. There are three files: 1. a color database that lists all the colors the item comes in. 2. a description database that lists the item descriptions. 3. a main database that pulls all that information together. In the main database, the color lookup only functions properly for the first entry in the item # field. Item 0120000 has Red/White/Blue in the value list which is accurate. For the second entry (#0120001) it should read Gray/Black/White as opposed to Red/White/Blue. This database is already existing and used extensively so changing to something other than repeating fields is not possible. Thanks again. VL_on_repeat.zip

I had that as a test scenario but ultimately ruled it out for being too ugly and I need tab access to the fields for data entry. In the real database, I have 30 repetitions of the fields so I'd need 90 scripts. If I were to use something other than a global, would that work?

I have a value list generated via a relationship to another FM DB and it's contents are controlled by the values in a repeating field. The problem is that I can only get it to work for the first repetition of the repeating field. Is there a work around?

After reviewing many posts here, I now understand the limitations to using repeating fields, I'll know better next time. I have been banging my head against my monitor all day trying to figure this out, please help. I have three repeating fields that represent information about a product: Item #, description and color. I need a global field to display what the Item # is for that line regardless if the current active field is Item #, description OR color. Thanks a ton.