i am trying to write a query to pull details for 1. Project transactions 2. vendor information 3. invoice information. Vendor Invoice Form has Vendor info invoice info Project details how to figure out so i can write a query and what tables to retrieve data from
i was able to figure it out.
on the form , use personalize to see the datasources involved and the relations between the tables.
is there any tool available which can give entity relations diagram which can help us understand the realtions without going through personalize manually. saves time