inserting picture templates

[chiefmsb]

I want to be able to add drawings using templates within the database record. I would probably have a dropdown menu of picture templates to choose from and then when the desired one is selected I want to ba able to draw on it and then save it to that record. Any help would be appreciated. Thanks

[June7]

You want to put the drawing file into an attachment field? This will make your database really huge, especially since sounds like there will be repeats.

Need a table for these drawings, either use a hyperlink (my preference) or attachment field. Each record would be unique. Could use autonumber field as primary key field. Then save this key as foreign key in the other table by selecting the template from a combobox that has the drawing table as RowSource.