In a dropdown from a referenced table expected behavior is a default selection based on the record you come from. I now have one situation without this default. I have to select manually. What am I missing?
I believe we haven’t understood your case. Can you please elaborate? May be with a screenshot, table schema etc.
Name House references to a table and gives me the dropdown.
Opening the dropdown gives me the list of houses. I expect a preselected choice based on the record I come from. Normally that works fine, but not here.
Which record are you coming from?? Is that Name House ref column is set with isPartOf?
Coming from Name House, then to Controls and then to Score.
Name House is not set with isPartOf.
I set it to isPartOf but doesn’t seem to help…
I’m not asking the field name…You have stated that “…I expect a preselected choice based on the record I come from…”. I’m asking from which record are you coming from?
Not sure what you mean, but this is where I come from:
Add brings me to the Score Form and the dropdown. in there. See above.
So you basically adding a child record for your parent table which is Apparatuur or whatever else it might be, via the Add button under the inline view. Is that correct?
Apparatuur = Devices or Controls
You should have a REF column in your Scores table. You can use a de-ref expression in the Initial Value of Score tables Form view to pre-select what you want.
[Name of House].[ColumnA] // replace with the actual column name that you want to fetch from the parent [Controls].[ColumnB] // replace with the actual column name that you want to fetch from the parent
That what I have. In fact Score is a joint table with 2 parents (Houses & Controls). Also the dereferences you suggest are there.
It’s rather quiet out there