Mutliple table selection

Question

Hi People , 
 Scenario : i need to fetch relevant data(using filters) from Table 1 and 
 from Table 1 Entries i need to fetch the relevant data from table 2 and 
 from table 2 entries i need to fetch the relevant data from table 3 . 
 and what can be the relation between these three tables which links them together . 
 
 *like multiple selection between multiple tables . 
 
 P.S : Myself, new to Appian environment.

Sandeep Deshmukh · Accepted Answer

Hi Vetrivelk, 
 
In this case you need to use Foreign Key concept in your tables. So here your Table 1 Primary key will act like a foreign key in rest of the table. And while fetching details in Appian from DB, I can suggest go with View in DB. I mean create a view in DB. 
 
I hope this is the correct answer of your query. 
 
Thanks, 
Sandeep

Smruti Swain · Answer

Hi there, Could you please clarify the requirement a little like the relationship between these 3 tables. If they have some referential integrity exists then you could create a database view joining them together and fetch the data from them. Thanks