I have a lot of linked documents to my orders in my Microsoft Access database. Now I need to be able to add one of the pictures, which is the customer's design of the product, to the order confirmation and other documents used in later processes. I have made a temporary solution with a DMAX query, but I think it's not the best and cleanest solution for the users.
I have a table called tbl_0_documents with 5 columns:
doc_id (AutoNumber)
order_id (Number
doc_type_id (Number)
doc_name (Short Text)
doc_description (Short Text)
There can be many repeated order_id's with the same doc_type_id, but I can only have one doc_type_id with a value of 11 per order_id.
Is it possible to somehow make an order_id along with a specific doc_type_id to be unique and if possible, how is it done?
