Dropdown referenced table

[Ewout_van_Zonne]

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?

[LeventK]

I believe we haven’t understood your case. Can you please elaborate? May be with a screenshot, table schema etc.

[Ewout_van_Zonne]

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.

[LeventK]

Ewout_van_Zonneveld:

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?

[Ewout_van_Zonne]

Coming from Name House, then to Controls and then to Score.

Name House is not set with isPartOf.

[LeventK]

Ewout_van_Zonneveld:

Opening the dropdown gives me the list of houses. I expect a preselected choice based on the record I come from.

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?

[Ewout_van_Zonne]

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.

[LeventK]

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?

[Ewout_van_Zonne]

Yep

Apparatuur = Devices or Controls

[LeventK]

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

[Ewout_van_Zonne]

I set it to isPartOf but doesn’t seem to help…

[Ewout_van_Zonne]

That what I have. In fact Score is a joint table with 2 parents (Houses & Controls). Also the dereferences you suggest are there.

[Ewout_van_Zonne]

Any thoughts?

[Ewout_van_Zonne]

It’s rather quiet out there