Combo Field

[Hack]

Hi

I have this problem with retro fitting Combo felds with value list and using pop up list

Attached is a clone of the data base

My problem is that my data base is growing I can not remember by Client ID with Client name or Project name with project ID and reference. So what I am trying to do it use and Combo field with pop up list to get around this issues.

But for example as you can see with the attached data base. With "Job instruction layout" I try to add an Combo felds with pop up list but it say "This action is cannot be performed because this field is not modifiable" or for the "Job title, project ID and Job ref" Combo it wont even show the pop up list???

So for the "Job instruction layout" I am just wonting to use combo pop list for the Cient and ID and also for the "Job title, project ID and Job ref" and also for it to work for the record so all the link data does not fall off

I am also hopping to use this same approach for my "print specs" layout as I have the same problem

Does anyone have fit for this problem? I would great appreacheate any one input

Regards

Damian

BD_job_tracking_test_v3Clone.fp7.zip

[aldipalo]

You can set the value list so it shows the company name, but enters the serialID. See attached.

HTH

BD_job_tracking_test_v3Clone_Copy.zip

[Hack]

Thank you very much that work the trick -]

Cheers

Damian