>1) I want to create a report so that each page is a seperate record. Easy enough. However, each record has a field which contains a bitmap picture filename. How do I display a different picture on each page. I've tried placing a Picture/OLE Bound Control and then setting the property to get the picture from the field which contains the name, but I get the message "Field must be a general field." when I Print Preview.
>
>2) Given the following 2 tables:
>

>agents      buildings
>  name        name
>  id          id
>

>agents.id = buildings.id (id is what links them together)
>
>If I'm printing a report of buildings, how do I print the agent's name corresponding to each building.  It seems as though I'll need to do a SELECT SQL statement somewhere.
>
>Thanks.

'Picture' report field can use UDF to retrieve different bitmap file names, i.e.

Function getpicture
If mytable.field1=1
 return c:\file1.bmp
else
 return c:\file2.bmp
endif

Edward Pikman
Independent Consultant