var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: A report from three different queries?
Is it possible to create a report that will draw from three different queries. The queries will provide:
(1) a list of all the invoices of a contract and their attributes
(2) a list of all the contract vendors and their attributes
(3) a list of all employees on the contract and their attributes
Any sample/examples out there.
Make three sub reports.. and embed all three in your main report.
This sounds like a very neat idea. Now the task for me is to find out how to do what you have just suggested. I have never done it.
Do you have any clues.
The trick is in two properties of your subform object.
Link Master fields
Link Child Fields
Link the contract ID to the master field.
Link the foreign key to ContractID to the child field.