Several Questions Regarding Reports....Help Needed!

[infinitx]

Hi,
I am making an item database management program and have several questions regarding reports.

Here is the basic overview of the table structure.......

ItemsTable
Item ID (Autonumber)
Item Text (OLE Object, is this a good choice?)
.......

CaseTable
Item ID (Autonumber)
Case Title (Text Field)
Case Text (OLE Object)

GraphicsTable
Item ID (Autonumber)
Graphic Title (Text Field)
Graphic (OLE Object)

First of all.......
I want the person to choose which items (according to Item ID) to appear on the report.

Would I have the person choose which items to appear on the report on a form and then add them to a Temporary Table?

Second of all......
When I try to view items in the report, it always puts only one item per page. I want it to display as many items as the report can fit.

Can these be done?

Thanks in advance!

 

[dhookom]

What are you storing in the OLE Object fields?
Do you want the user to select multiple items to print?
How are these tables related? If CaseTable and GraphicsTable are related to ItemsTable by ItemID then the field types in the two related tables should be Long Integer, not Autonumber.

I responded to another thread where you asked about more than one item per page.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.