DefaultSelectedItems not working on all Combo Boxes

[RABronn]

I have two combo boxes on my form. On one, the DefaultSelectedItems works, and on the other it doesn't. Both pull from separate lists and neither list is part of the list I am saving the details to.

Property	Working one	Not working one	Comments
Layout	Single	Double	Tried changing to single, didn't work.
Items	Datasource.Title	Datasource (no column)	Tried Datasource.Column, didn't work (I also need the other columns).
DefaultSelectedItems	{Title: ThisItem.Column}	{Order: ThisItem.Column}	Also tried: {Order: DataCard1.Default} and {Order: Parent.Default}

I can't work out why one works and one doesn't.

[RandyHayes · Accepted solution]

@RABronn 
The DefaultSelectedItems (DSI) of your "not working" control is not correct.  It is specifying a record that has a single column called Order, yet your Items property is all columns of the record of your datasource...so it will not match.

I would suggest narrowing the Items to the column that you are specifying in the DSI - DataSource.Order

Or, performing a lookup on the record from your datasource - LookUp(DataSource, Order=Parent.Default)

Otherwise, the DSI and the Items will not match and you will not have results.

I hope this is helpful for you.

[RABronn]

That makes sense, thank you for explaining. Your second suggestion works and is exactly what I needed.

I did try changing the Items property to DataSource.Order previously as I thought it could be that, but it did not work. I'm not sure why as it sounds like it should have done (although it wouldn't have been the best solution for me).

[RandyHayes]

@RABronn 

Glad to help.

Yes, the first would work - it might not provide the results you want, but the DSI would at least match the record properly.