Relationship help please!!!!

[Marshall Barton]

I have multiple tables.

Customer Info
Product Info
Shipping Info
etc.

I am working on making a report (invoice) to print. How can I set it up to
where I can put info from all tables into a single, one page, report?

Whats confusing me is there will be more than one record source so you can't
just select a control for each item. I'm sure I need a relationship setup
but not sure how. Any help would be greatly appreciated. Thank you

The key to creating a report is to first figure out what
data you want in the report and then to create a query that
retrieves the data. In you case, it sounds like you want to
Join the tables (add the needed tables to the query) and
select the fields from the various tables. Then you can use
the report's Sorting and Grouping window to create headers
for the parent fields (eg. customer info) and put the child
table fields in the detail section. This works well when
the tables are related like aa parent/child/grandchild
relationship.

If you two independent child tables that only join to the
parent table, then you should exclude at least one of those
tables from the query and create a subreport for the table.
Use the subreport control's Link Master/Child properties to
specify the linking fields.

Creating relationships using the Relationshos Window is
always a good idea, but it won't affect the report beyond
automatically linking the tables in the query.

 

[Scott_66701 via AccessMonster.com]

I have multiple tables.

Customer Info
Product Info
Shipping Info
etc.

I am working on making a report (invoice) to print. How can I set it up to
where I can put info from all tables into a single, one page, report?

Whats confusing me is there will be more than one record source so you can't
just select a control for each item. I'm sure I need a relationship setup
but not sure how. Any help would be greatly appreciated. Thank you

 

[PieterLinden via AccessMonster.com]

Create a query that joins all the tables you need and that returns all the
records you want in your report. Then you can create the report and filter
it in the Open event.