Form & subform in report

[Igor G.]

I have two tables, products and customers...
From first I call data in form (products), and from second in subform (who
buy some product).
I have query in report, product have ID and customers in subform IOI ID.
How to in same query combine data for report from unique ID in form and IOI
ID from subform.

Example:
I filter ID from form products by code: [Forms]![Products]![ID]
Problem is when I call some IOI ID from subform in combination with form data.
How to filter some IOI ID from subform?

 

[Allen Browne]

Presumably the connection between products and customers occurs when a
customer buys a product, and that's what want the report for?

If so, you need 2 more table to handle the customer orders:
- an Orders table (fields like CustomerID, OrderDate), and
- an OrderDetails table (to handle the line items in the order.)

If that's a new concept, open the Northwind sample database that installs
with Access. Then open the Relationships window (Tools menu.) See how the
tables fit together. That's what you need to do.

When you have the tables in place, you will create an Orders form, with a
subform for entering the products in that order. Again Northwind provides
the example of such a form.

Once that's done, you can create the report to print the order in the form.