I'm finding it difficult to get MS reporting working to what I'd like to show.

What I'm trying to do is:

a) In my database store a URL file (HTTP external file), that is a .jpeg. I'd like to use that URL to call the image on the report sheet. I have tried to use 'Control source' on the data panel, but with no success. Any way I can get Dynamic Images to show up on each database.

Also, I have a couple of Relational Databases.

One Defines Values:

For Example:

DefinePets('petID','Name of Pet')

The other one links the Main DB with the 'DefinePets' database.

Eg:

connect('petID','mainID','extraFeild')

I'd like my report to Go into the "connect" Table, where the the currently viewed Record Value = mainID, then find petID and return Name of Pet.

There is a many to many link between definePets and the main Table. (Therefore connect is joining them up)

Or is that too much to ask from a simple package like Access?