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.