Jump to content

value list from 2 fields in different files


George Swisher
 Share

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

Recommended Posts

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

Link to comment
Share on other sites

  • 4 weeks later...

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!

Link to comment
Share on other sites

This topic is 6558 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.