value list from 2 fields in different files

January 12, 200421 yr

I tried to find the answer in the Forum but no luck.

Here is what I have:

Two files call Vendors and Staff.

I have a Job Ticket database that is related to these files and created relationships/Value list called VendorsList and StaffList, which is all the codes I use for each file

(Ex: GWS for George Swisher in Staff file, and SYST for System in the Vendors file)

I use vendors and staff to assign tasks to be completed, that is created in the Job Ticket Database.

I have a field in Job Tickets call AssignTo, which needs to be a a drop-down menu with values from both files.

What is the best way to do this?

-george

4 weeks later...

February 4, 200421 yr

Just guess, but what about, using a calc field to combine the two values.

For instance Field=(Vendor &" "&Staff) (Iput a space in, but you do not need it. Then either make that calc for your value list, or seet your value list equal to that field.

Hope that is right, let me know if I completly missed what you were going after!