I don’t really know how to search this question so I’m just going to post it
I have 2 tables on has the data for incidents ex incident ,date,job number then the other table is all he accounts for existing clients so Client, account details etc i want to have i in a way i can select the account table but i want to show the associated job numbers of that account so i can see what clients are more prone to creating reports
Not sure I understand, but try this article: https://support.google.com/appsheet/answer/10106510?hl=en
1 Like
What do you mean by this? Please be specific.
1 Like
so i have a table A Incident , Date , JobNumber
table B Client , Number ,
i have the incident table relating to the client table to say these are the clients you can choose from
but i want to have the client table relating to A to say client A had job 1,2 ,3 so i can know what client has multiple reported incidents and is it just one or two accidents
Yes this is a ViritualColumn with REF in the Table B. Under each client you can then show a sub-list (sub-table) of all the related Icidents related to the client. You should read the article I sent you 
Its quite basic.
1 Like