Multi Fields from value list
I have a value list which is linked to a table with many different fields. When the user selects an item from the list i want 3 more related fields from that table to appear on the layout. How do i do this ?
So when the user selects orange for example then relates fields on the same row in the table (fruit, citrus, juicy) also appear on the layout.
Any help would be greatly appreciated !