Lookup

[chris_brown]

Hi, I have 2 pop up menus 1 called machine and one called ink, what I want to do is be able to select machine and it atomatically selects the ink that the machine uses.

Thanks for any help

Chris

[andygaunt]

Hi,

sounds like you need a conditional value list.

Where are your machine and inks located.

Are they just in value lists.

The best thing is to create a db of machine and inks.

Create two fields machine and ink. Each item is a new record.

Then set your first popup to use values from field, specify the new file and choose show all values from machine field.

The second value list then uses values from a field, specify but this time choose only related values.

define a new relationship from your first popup field to the new db machine field. Click ok and then choose the ink field.

So, when you select the first popup and choose a machine, the second popup will only show the related items to that machine.

Benefit of this is if you add another ink for a machine you just create a new record in the new database.