I have a value list that should get all records from 3 tables. I could do it with 2 if I have a value list lookup and choose first and second field. But what if I need a third? How can I list a field from 3 different fields and show it in one value list?

I tried to create a calculation field and added:

add_materials::add_name &

eo_materials::eo_name &

oil_materials:il_name

that should list all 3 tabels name fields in one calculation.

The problem is that it wont work because it cannot index the field. So how can I list all 3 tables name fields in one value list?

Thanks

That is not how value lists are used.

Value lists are simply lists of values. They can be "custom" lists that are manually typed, or they can be based on values in a field.

The option to display second values from a second field is intended to be used to allow the entry of a serial or id number into a field, while displaying a human-readable description to aid in the value's identification.

"I have a value list that should get all records from 3 tables."

Value lists cannot do this. They can get values from one table only. This is usually never a problem in a well designed system.

I'd suggest that the 3 table setup containing similar information needs to be reconsidered.

Totally agree with the principals that Vaughan has already explained and would add one other point:

if you create a value list (use values from field) where you decide to show a second field, then that second field can come from a related table occurrence

Simon