AppGini Community Forums

Hi,

I see Appgini does have an option to combine 2 lookup field options from one table into another table as a lookup field option but how do I combine more than 2 fields into one lookup field option?

For example the lookup field options: Colour: Blue, Green & Weight: 1kg, 2kg & Category: Flight, Ground & Type: Single, Double

So the table options to lookup to combine more than one field for example would be:
1. Blue 1kg Flight Single
2. Blue 1kg Flight Double
3. Blue 2kg Flight Single
4. Blue 2kg Flight Double
5. Blue 1kg Ground Single
6. Blue 1kg Ground Double
7. Blue 2kg Ground Single
8. Blue 2kg Ground Double
9. Green 1kg Flight Single

And so on and on...

So the options to choose from would then be from these 9 mentioned above (which has been compiled by other fields)

How to do this please?

This is related to post of viewtopic.php?f=8&t=4951&sid=ff62150f3e ... 31929cc0ce

Thanks for the help,

Kind Regards,
Richard

Hi,
you can use the advance SQL setting within appgini to concatenate whatever information you want to display on the lookup.