Return both fields from value list
Is there somewhere I can set the value list to return both fields that are displayed?
You can do it...you just need the right relationships.
For example, if you are showing unique id and a name, the value will set the one field. Then you can place another field to display the name from that related table.
If you are talking about pulling in 2 fields without using a unique identifier...then it is a little trickier and you will need to provide some more detail about your setup and what you are trying to do.
I am not sure what you are saying.
I have a value list that displays two fields:
Doctor Name and Doctor ID.
When I select from the value list it shows only Doctor Name in the field. The Doctor ID does not show.
Add a second field from the related table next to the first to supply the missing information.
Thank you for answering my request.
In Manage Value Lists; Edit Value List; Specify Field;
It asks to use values from First Field (Doctor Name), then there is a radio button to display a Second Field (Doctor ID), which I also check.
Entering the field in Browse Mode, activates the drop down which displays both fields. When selected the first field only is assigned. Is there an option to assign both fields?
Your statement "Add a second field from the related table" begs 2 questions:
1. What related table? I don't think I have one.
2. Where do I add it (in the manage Value List Dialogue; or in the layout)?
Do you mean:
On the Value List, Have the ID as the first field.
Relate the table to the Doctor file on ID
Then place a field on the Layout from the Doctor file called Doctor Name
I believe it needs to be the other way round: make Doctor ID the first field in the value list definition, and Name the second one.
3WAVEGUY wrote:What related table? I don't think I have one. Then what is this for?
What related table? I don't think I have one.
Then what is this for?
Retrieving data ...