Join/merge tables

[Anton_Rybak]

This question has already been asked, but I just want to make sure I get this right.
Let’s say it’s accounting app, that work with documents (invoices, orders, etc). Each document should have it’s own table. If I want to show all the documents in one view, in SQL I would do something like “SELECT * FROM Table1 JOIN Table2 JOIN Table3 …”
In AppSheet it should be a master table, that have links to all the different types of documents. And then, each table should have two events (add & delete) and two actions to update the master table. Is this the best way to do it?
Thank you!

[takuya_miyai]

Hi @Anton_Rybak

How about creating only one document table and creating a record type column?
In the record type column, you can specify invoices, orders, etc., and use the Condition Rule of Action or Workflow for each document type.

Also, I think there are many items that can be standardized such as the date of issue.

Thanks,

@tsuji_koichi