ID is Primary Key (DataType=AutoNumber)
Problem_ID is (DataType=Number) (Indexed Yes No Duplicates)
Attachment is (DataType=Attachment) (Required = No)
The form "Problem Records Details" has an Unbound object called Attachment. I would like the user to be able to insert an attachment from this form. I have tried the following as the control source:
Expand|Select|Wrap|Line Numbers
- SELECT [Attachment] FROM [Attachments] WHERE [Problem_ID]=Forms![Problem Records Details]![ID];
This does not seem to be working. Any help, ideas, or insight would be greatly appreciated.
Thank you in advance.
Regards,
Catalyst