Hi there!
I am trying to create a dropdown on my form that comes from a related table. I want to display text for the user, but save value to by database as a number.
Here is the table my form is created from:
***Important note: this table is update only.
('Rating' column is an integer in my database)
Here is the table it's referencing:
These are the property conditions in the table:
This is the current Ratings dropdown in my form, and I would like it to instead show the property conditions above.
Initially I tried using [Rating].[Property Condition] in the formula, but that doesn't work. I now realize that won't give me a list like I want.
Then I thought, create a virtual column: REF_ROWS("Rating", "Property Condition") and in the 'Ratings' column create an expression to get the selected Property Conditions associated id. This also didn't work... gave me an error saying my table does not allow adds.
Is what I'm trying to do possible? Or, is there any way I could hardcode these text values to get the associated id?
Thank you for any help!
Solved! Go to Solution.
Mark "Property Condition" column as Label.
Just this.
Ha! I love a simple solution, thanks for all your help Joseph!
User | Count |
---|---|
33 | |
25 | |
23 | |
23 | |
15 |