Hi,
I know that you can reference two fields from a table on a single single field as foreign keys inside of the program. How do I make to show more than two fields from another table?
This is what I want to acomplish:
I have table 1
Table 1 has: field 1, Field 2, and field 3
I have table 2 from table 2 I want to show and be able to merge in a csv file Field 1, Field 2 and Field 3 from table 1.
currently is easy on the program to combine Field 1 and Field 2 only if you reference those as a lookup field but only allows you to reference only two fields.
How to enable showing more than two fields in a single field?
-
- Veteran Member
- Posts: 90
- Joined: 2015-11-23 01:02
Re: How to enable showing more than two fields in a single field?
Try using the "Advanced" button in the lookup tab to create a custom query combining the 3 fields. For more details, check the "Customizing lookup contents" screencast.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.