I create a Value List.
Set it to Use values from field.
click Specify field...
Select a first field (this happens to be a primary key in a related
table).
Select a second field (this happens to be an IP address field).
Check Show values only from second field.
So, I have a field in my layout that I have set as a drop down menu
pulling from the value list.
If I click on it, I see a list of IP Addresses.
I select the desired address and hit enter.
The field now reverts back to showing the Primary key (in this case
ip0000001)
I know this is the expected result.
But, this makes it hard to look briefly at a record and see what the
IP address is for a particular computer.
Instead of seeing the IP address, I see the Primary key.
I know I can place the IP address field as a related field and
problem solved.
But, from an end user's point of view, there is a disconnect between
where you click to set the IP address, and where the data actually
appears.
Is there any way to have the field in question continue to show the
data from the second field, rather than reverting back to the first
field data?
Alternatively, how do others deal with this from a layout design
standpoint?
I tried some tricks with stacked fields, transparent backgrounds, and
opposite text justification for each field; but the problem is that
when the record is active in browse mode, all the fields have white
backgrounds, regardless of what they are set to be for printing and
viewing purposes.
Anyway, any help is appreciated.
Thanks,
b0b
--
Bob Sandkam
MacOS Support
Information Technology Specialist II
VCUarts Computer Center
School of the Arts
Virginia Commonwealth University
