Inheriting default fields into a list box using an expression

[tinkerz1]

I have an address field for location and a name field, both are in the same state and linked from the same database upload.

In order to get right data out I need to use the location rather that the name to pivot around.

However some names dont have locations, in order to have good governance I can record the names without locations and make the changes to the database.

This leave me with an issue:

I want the list box of names to have another column thats inherits the locations from the default load, not the state.

My current expresion adds column but does not bring through any data.

=[Issue - Location L3]=[BCC HBFR Mkt Stats]::[Issue - Location L3]

How can I do this?

Thanks,

Neil,

[#2]

Add the new column in the script if Location is null assign default value to Location field.

[tinkerz1]

I need to be more specific, when a higher level grouping is applied I can see all the locations, but once I select a location all the I see in the dual list box of name and location is the name and the locations I select.

All the others are now '-' and greyed out, if I could see the locations then as user and ctrl + select name to add to the list, probably from the blank locations that are in the dual owner location list box, so I need that group to inherit the location

Thanks

Neil.