Converted ValueList to Related Table; Need to reload data into existing Records

[Veronica]

I've converted a Customized ValueList containing a code and code description to a related table occurance with an ID field, code field & code desription field. I need to load the existing records in the main table occurance with the values from the original value list. I've tried importing, I've tried doing a find on a particular value from the value list field and then attempted a replace field contents on the two new fields from the related table which are displayed on the layout of the main table occurance. It only worked on the record I was in. Is there any way of putting the correct codes and code descriptions in the matching records?

[David McQueen]

I am not clear on exactly how you are going about this.

If you have an existing description in the main table for existing records, there is really nothing you have to do with them. They presumably were already selected using the value list.

The problem then becomes selecting a description for new records.

Set up either a cross product relationship (FMP7 or above) or set up a constant to constant relationship to get a selection portal of descriptions and ID's. Then script a transfer of the description ID to the main table record when clicking on the item in the selection portal and have the description ID transfer cause a look up for the description.

HTH

Dave McQueen