Thank you for simply existing! I’ve really given my best to get to where I am at with this task but is way over my head at this point. So hopefuly you guys can help!
I have my tables: Orders (Ordenes), Products (Productos), Clients (Clientes), Address (Direcciones) tables. I have an “Address Type” field (Tipo_Direccion) on my Address table.
For some clients we will have their address, from some others we won’t. While filling out the order, I am trying to show all the addresses we have for the specific client on a drop-down menu where I concatenate the address type (home+address, office+address, other+address) and show it so the person filling out the form can pick one of the three if existant addresses to ship the product to.
I created a virtual column using “Concatenate(… (Select…))” and called it from the “Valid_if” expression in the Orders.Address column, the concatenate works fine, it shows both pieces of info in my drop down, the address type + address. However when there are more than 1 address+ address type associated to one client, it shows one single line in my dropdown with all (3) address types and addresses concatenated in one field for that client.
This is how a client with 3 addresses shows:
3 address types first separated by column, then the 3 addresses concatenated all in one single list item to click on
This is the addresses table:
The virtual column:
The concatenate expression:
The column in “Orders” where I call the addresses from:
The validity field expression: