Jump to content

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


Veronica
 Share

This topic is 5786 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5786 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.