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
How to combine more than 2 fields into one option as lookup
Re: How to combine more than 2 fields into one option as lookup
Hi,
you can use the advance SQL setting within appgini to concatenate whatever information you want to display on the lookup.
you can use the advance SQL setting within appgini to concatenate whatever information you want to display on the lookup.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.