Question
Update/ Displaying Descriptions from related file
In an update program using master/detail I have several
fields that are id's to other files that contain descriptions.
The detail displays the current values of the record along with a column for changed/new values.
I would like to display the description in the current value column along with a drop-down list in the changed/new value column that would allow the user choose a different description.
I have recordsets for the file that is being updated(1) and the file(2) that contains the description. The recordid in file 1 is being updated but I can't get the name to display. There are about files (for descriptions) that I need to include. In addition to getting a direct answer to my query, I'm also not sure of where to start looking on the forum for similar requests to take advantage of what has already been covered.
PS. I appreciate the help I received last week resolving a sqldate question.
The detail displays the current values of the record along with a column for changed/new values.
I would like to display the description in the current value column along with a drop-down list in the changed/new value column that would allow the user choose a different description.
I have recordsets for the file that is being updated(1) and the file(2) that contains the description. The recordid in file 1 is being updated but I can't get the name to display. There are about files (for descriptions) that I need to include. In addition to getting a direct answer to my query, I'm also not sure of where to start looking on the forum for similar requests to take advantage of what has already been covered.
PS. I appreciate the help I received last week resolving a sqldate question.
AdChoices