So I will try to explain by the picture above. they are list boxes, the 2nd column on a list box is an expression for both Name list boxes
I have 1 named state and one inherited state, on the left <state 1> I select france and and all the countries go '-'
The expression is just 'Location' in the Name field.
What I want is to hold the countries as in the 'Inherited state', thats why I thought after the selection you need an expression to look and inherited and pull in the original data.
My second question is in both states blanks to not show up, my thoughts are in the loading script to fill out these blanks with a '-' so you can see there are blanks in the data, or does QV have a solution for this in the settings?
as expression in your list box, try
With regard to blanks (I think you are referring to NULL) are not showing up, I think that is default behaviour, NULL is not a value.
You can try changing that (search for NULLASVALUE), or just creating a dummy value while loading:
if(len(trim(Location)), Location, '--') as Location,
if(len(trim(Name)), Name, '--') as Name,