macfundi
asked on
Placing information from multiple tables into a printed layout wihout using portals
I have one table that holds all orders. I have another table that holds items the person bought. I have another table that shows what the person paid.
How do I create a receipt (layout) that is based on the orders table and list all the purchased items and the payments below that?
I don't want to do this using portals- this is for printing and needs to hold infinite amounts of information.
How do I create a receipt (layout) that is based on the orders table and list all the purchased items and the payments below that?
I don't want to do this using portals- this is for printing and needs to hold infinite amounts of information.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.lesouef.net/files/records_conc.fp7
its is made for 3 pages max, but can be extended to n pages.
waiting for yr comments if any.
its is made for 3 pages max, but can be extended to n pages.
waiting for yr comments if any.
ASKER