get value from dropbox
here is my question, I have designed my dropbox like this pic
I am trying to get value from first field. is any get function i could use it or any suggestion for me to solve this problem
Thank you for your post.
You can reference the field Ds_ID directly, as it stores the value, even if it displays something else.
If you want the Ds_ID contents, then uncheck the option "Show values only from second field", as this will then show both fields.
thanks it works
what if i hide DS_ID and just show name on dropbox, can i write a getvalue() in script to catch DS_ID in this situation?
Yes. The contents of the field do not change. It is only the display that changes. Even with the Name showing, if you just queried the field, it would return the Ds_ID contents; not the Name.
instead of getting DS_id, is that possible to get a name in this situation ?
If you want the Name, simply reference the Name field.
If the table that is the source of the values of the value list is linked in a relationship to your layout's table. Once you used this value list to enter an ID, you can have the name field from the related table on your layout display the name.
A popup menu can show the name automatically if you hide the first field values.
I recommend that you download Adventures In FileMaking #1 (It's free) and read, play around with the section titled "Defining Field Based Value Lists" as a primer on how to set up and use this kind of value list.
Caulkins Consulting, Home of Adventures In FileMaking
Retrieving data ...