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:
DefinePets('petID','Name of Pet')
The other one links the Main DB with the 'DefinePets' database.
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?