HI,
I would like to retrieve ALL IN/OUT transactions in my system such as sales, stock in, transfer and etc.
Previously, I opened all relevant tables, SELECT the records and UNION ALL into a single cursor. However I found it takes alot of resource.

Therefore, I plan to have an extra table that store only necessary fields, of ALL transactions. The records will be inserted/updated during data entry of every transaction (like duplicated). Then I can access all transactions records from this table everytime.

Do you think it would be faster?
Any comments?

Thank you