I have a table of hinges and handle

[ClydeData]

I have a table of hinges and handles etc on doors the table is normalised with the fields

DoorID SERIALNO Quantity photo

I wish to pivot this table in order to present small photos of the items on a in a report or form in tabular continious form/report format with field headings

photo1 photo2 photo3 etc

Any suggestions

Jimmy

 

[mph1]

Jimmy,

I am not sure that what you are trying can be done on a contious form. Check the Northwinds sample for some ideas on how to present a picture that corresponds to a part. In the Nothwinds, I believe the picture relates to the employee.


Good Luck

Maurie An investment in knowledge always pays the best dividends.

by Benjamin Franklin