Sweet victory!
After struggling for a week with the same problem, I have a solution (recorded here for the aeons, of course).
Challenge: To get a drop-down menu, populated by a value list populated by a field in a related table, to display *all* the records' data in that field, not just the first record's. Apparently you can't use a calculation field (which I was trying to do) if you want to do this.
In my case, after the user enters a first name, last name, suffice, and honorific, I want to have a field calculate the complete name and title of the given person. Then I want this info to appear in a drop-down menu elsewhere.
What threw me off is that calculation fields don't seem to work properly, on account of not being directly editable. The workaround I finally used is to set the field for the calculated value to a Text field (not calculation) and then tell it to insert calculated data automatically.
I'm not sure that I've got all the bugs worked out yet. Nevertheless, it feels good to get this far!
Update: To prevent the field from being modifiable by hand (as opposed to calculation), just select the option to prevent modification during data entry.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment