Dual Image displayon forms.

[Aeon.Divine]

Hi there, im designing a database for my office, and i'm lacking some information, i hope you can help me a little here. I have a report, which shows a list of products and their characteristics. In the product table theres an image field, to input the photographs or diagrams of each register. When it comes to show the pictures in the report, i need it to show as much images as the user entered on the register. But i don't know how to do so. the images must be distributed properly, so i cant just create 4 image independent fields not only because it would limit the number of pictures but also because if i would not input 4 pictures, the report would show a lot of empty space.

So then, has anyone been caught in something like this ? Does anyone know how to work this out ?

I would certainly apreciate it. Thanks in advance.

 

[Aeon.Divine]

So, no one knows ??...

 

[Aeon.Divine]

Gee.. so no one has ever get across such a thing... well then, i'll look for it in other place. Thanks anyways.

 

[flect]

You'll probably find that many people have had a similar problem, but perhaps not the explicit problem you're having.

Can you maybe give some more information ie. table layouts, queries, & how your reports are attempting to access this information.

You say " i need it to show as much images as the user entered on the register" - so why can't you just query all results entered(x) on

by user for product(z)? (ie SELECT [x] FROM

WHERE [y] = ? & [z] = ?)

A lot more information is needed, try to be as explicit as possible when describing your problem.

 

[Aeon.Divine]

The problem is really simple, when you display a picture field in a report, this field only shows one of the several pictures you could have previously loaded into that field. I want to know if theres a way of showing everyone of this pictures, wihout having to make a new table called picture, to where ill load several picture registers to then load them into the report.