Auto enter data in value list depending on another

[Sticklebrick]

Hi,

I am currently creating an image database. I have a value list of about 40 projects that an image has been used in, and another value list of corresponding project codes. Some images have been used in more than one project so I have the lists displayed as checkbox sets. I would like to be able to set it up so that when the user checks boxes in the project list, the corresponding project code boxes also to become checked, and vice versa. Is this possible? I can get it to work if only a single box is checked (using the auto-enter calculated value option and setting up a case statement), but doesn't work if i check more than one box. Can anyone help? Hope this all makes sense.

Thanks!

[Sticklebrick]

Hi,

I am currently creating an image database. I have a value list of about 40 projects that an image has been used in, and another value list of corresponding project codes. Some images have been used in more than one project so I have the lists displayed as checkbox sets. I would like to be able to set it up so that when the user checks boxes in the project list, the corresponding project code boxes also to become checked, and vice versa. Is this possible? I can get it to work if only a single box is checked (using the auto-enter calculated value option and setting up a case statement), but doesn't work if i check more than one box. Can anyone help? Hope this all makes sense.

Thanks!

[Brian C]

You may want to consider combining the 2 value lists if it is a one to one relationship between each value.

If I understand your setup is something like this:

(Key: DB = Database/Table, VL = Value List)

DB = Images

VL = Project names

VL = Project codes

Do the entries in each of the value lists match one another?

example:

Does Project Code "001" always match to Project Name "Newsletter" ?

If each code is always suppose to match to a specific name and visa versa:

1) Create a new table to combine both value lists into one called "VL_Projects" if you do not already have a table that has the project name and matching ID stored.

2) VL_Projects should have the fields: Proj_ID and Proj_Name.

Using this setup each record will represent a specific project and its cooresponding ID:

001 Newsletter

002 Fiscal Summary

003 Office Party

3) Now just change the value list for your ID to "Use Values From Field", select the Proj_ID as your first field, and check the box for "Also display values from second field and choose Proj_Name.

In this way, your checkbox approach will show both the ID and the name at the same time, and it will only store the ID number.