I am trying to use a value list to display a job selection field that is easier for a user to view.

I am using related value lists to display and use JobID numbers associated with a spefic job name. For instance, job_001 is a unique record with a decrption field of "Uptown".

In the selection field, the user selects a drop down list of a value list of all related jobID's, but it only shows text from the second field, the job description, i.e. "uptown", "downtown", etc.

That part works great. The problem is that when we create an invoice. When the user selects the "invoice" button to run a script, it creates a new record in my invoice table, and pulls info from the record they are modifiying. The only problem is that the job selection field that is showing "uptown" in a pop up field is really "job_001". The job discription is important to show up on the invoice record for the customer to see.

I've been searching for a while, and I can't seem to find how to get the text from that field to copy into a description field in the invoice record.

Any help would be much appricated.

p.s. I have already tried leaving the jobID as an ID number in the invoice table, and displaying it as a pop up list using the same value list, but since the value list only shows related records (jobs that associated with the division) I can't recreate that same value list on the invoice side

I think I found a way, but if someone could advise me if this is the best way or preffered way...

When creating the new invoice records in a new table, I relate the entire table of jobs to the jobID from the new invoice record to the jobID in the jobs table. I then use a lookup field to copy the related text description.