Drop down list using 2 fields

[Ninjapowa]

Hello, I would like to create a drop down list using 2 different fields from 2 different tables.

any way of doing this?

PS - I did a search, and found a few links, but nothing about using multiple tables...

thanks!

[netcode]

create a drop down menu.. under your value list go into manage value list. create a new one and it will ask you for values, here you can specify it to use data from a field, then you can select you two fields. it will only store the first field though, not the second.

[Ninjapowa]

So this means that I can't merge 2 drop lists together to create 1 drop list?