Displaying attachment of unlinked field

[ksapaugh]

I am not sure exactly how to describe what I am trying to do, but I am totally stuck.



I have a database for a food service company. There are only two tables: 1.)recipe table 2.)weekly menu table.

The recipe table has the following fields:
ID
RecipeName
Type
Category
Attachment

The weekly menu has dozens of fields in this general pattern:
Lunch Entree 1_1
Lunch Entree 1_2
Lunch Side 1_1
Lunch Side 1_2
Etc...

Each of the fields in the weekly menu are populated by the a query of the recipe table. then I run a report to create a weekly menu and daily menu from the Weekly Menu table. All of this works fine. What I am stuck on is displaying the attachment (actual recipe as a jpg) of the weekly menu.

For example if Lunch Entree3_1 is "Grilled Chicken", I want the report to display the attachment on the record called "grilled chicken" in the Recipe Table. I don't think it is that hard but I cannot seem to build an expression to make this happen.

Any help is appreciated.

[NTC]

If it is not too late; abandon the Attachment field type - and instead put the path/filename into a text field type. The Attachment field type is difficult to work with and bloats the database.

Add an Image control to the report.
After you add and save the image control, delete it's pictureproperty.
Code the Detail Section's On Format event (if the picture is in the detailsection): Me!ImageName.Picture = Me![FieldNameWithPath]

when ever you link to exterior images then it is going to be critical to maintain the path/folder names for the long term otherwise the links get broken....

[ksapaugh]

It's not too late. The database only contains info for testing.

What field type should I use in the table to hold the attachment? a hyperlink?

Thanks for your help.

[NTC]

for this type requirement one would use just a text field type. the hyperlink field type would be for if you wish to click on a hot link (and then the image opens outside the database in a Window).