G
grupy
Im looking to create an invoice report that uses data from three differen
tables that are created dynamically by a query. The data for these wil
chang
but I would like to simply pull the data from these tables to create a report
The tables have the following information
1. Company Info (name, address
2. Customer Info (address, name, etc
3. Customer Order (products, price, other info
4. Invoice Info (ID, GST #, etc
I realize I could have created a table with relationships but the data abov
i
dynamic as there are 4 different companies and based upon user input th
appropriate company information is saved into a new table. The same goes fo
Customer Info and their order
Any insight into this would be greatly appreciated.
tables that are created dynamically by a query. The data for these wil
chang
but I would like to simply pull the data from these tables to create a report
The tables have the following information
1. Company Info (name, address
2. Customer Info (address, name, etc
3. Customer Order (products, price, other info
4. Invoice Info (ID, GST #, etc
I realize I could have created a table with relationships but the data abov
i
dynamic as there are 4 different companies and based upon user input th
appropriate company information is saved into a new table. The same goes fo
Customer Info and their order
Any insight into this would be greatly appreciated.