by Hello:
This may be simple question, but I donot seem to find the answer! Can anyone
pls help me!
My problem is:
I have 3 tables: project, budget and obligate with Contractno as the key
field in first one and contractno and FiscalYear (Composite key) on other
two! I want to design a report based on user's selction of the some of the
fields in the table, such as contractor or name in project table and fiscal
year from other two! Anyway, I have created a query and a form that
supplies this info and creates the table with necessary information for the
report.
MY QUESTION IS:
How can I create/design two tables and other information on the report.
Specifically I want my report to look like
-------------------
COTR :
Project :
______________________________________
In short, how can I define two table frames, in report based on single table.
I tried to add the answer.db (second) table in my data model, and tried to
define table form that, but the only field selection it let me do is summary
operations, which I donot need!
Please help me out !
Thanks in Advance
Bhargav Desai