Lookup field in report

[Guest]

Hi,
I have created an access application that is intended to be used on seperate
projects, that is one application will be for project 1 and another for
project 2 and so on. What I would like to do is have a field in the header of
my reports that will draw its value from the project table so that each
report will show which project it came from. The project table will always
have one value. Alternatively, there is an image in the switchboard that
would be great to use. Is there a way that I could link the field in each
report to that image in 'FRM_Main_Menu'? many thanks

 

[John Vinson]

Hi,
I have created an access application that is intended to be used on seperate
projects, that is one application will be for project 1 and another for
project 2 and so on. What I would like to do is have a field in the header of
my reports that will draw its value from the project table so that each
report will show which project it came from. The project table will always
have one value. Alternatively, there is an image in the switchboard that
would be great to use. Is there a way that I could link the field in each
report to that image in 'FRM_Main_Menu'? many thanks

First off... lose the Lookup field in your table. As you are seeing,
it doesn't provide much benefit beyond making it easier to use table
datasheets (which is actually a *detriment* rather than a benefit:
Forms are much better suited for data entry and editing).

Base the Report on a Query linking to the Project table (which should
have as many records as you have projects). Having a separate database
for each project vastly multiplies the complexity of your application,
and should be done ONLY if the projects are totally and completely
independent, don't share common lookup tables such as lists of
personnel, and probably are running on unconnected computers.

To display images on a report, it's best to store the image file
externally. Access is *very* inefficient at handling image data
currently. Just store the path and filename of the .jpg or other image
file, and put an Image control on your report; fill it in the Report's
Open or OnFormat event.

John W. Vinson[MVP]