Hi,
Sorry, the above description isn't very good. I currently have an Order Details Table that holds the individual part number information for jobs. This table uses a couple of attachment type fields and as such is now getting very large. I am looking to split the table so that the attachments fields can be put into a separate back end thus reducing the size of the Order back end database.
I originally intended to use a make-table query based on age, but because the attachment type is a multi-value field this query type can't be used. I understand that the attachment type is not recommended but it works well for my purpose and hence I'm reluctant to change it.
I have now decided to manually split the order detail table, but when I create the query to re-join the fields back together, the database can't find a record in the attachments table with the matching orderdetail id when I try to add a new record. How do I set up the joining query so that a new record is created in the attachments table each time a new record is created in the order detail table?
Setup is as below:-
OrderDetailT
- ID (PK)
- OrderID
- Part Number etc
AttachmentT
- AttachmentID (PK)
- OrderDetailID (Linked to ID on the OrderDetailT)
- Attachment
I have the OrderDetailID in the AttachmentT as Indexed Yes (No Duplicates)
I thought that I did not require an AttachmentID field in the AttachmentT, but it is not working if I take this out either.
Thanks
Sorry, the above description isn't very good. I currently have an Order Details Table that holds the individual part number information for jobs. This table uses a couple of attachment type fields and as such is now getting very large. I am looking to split the table so that the attachments fields can be put into a separate back end thus reducing the size of the Order back end database.
I originally intended to use a make-table query based on age, but because the attachment type is a multi-value field this query type can't be used. I understand that the attachment type is not recommended but it works well for my purpose and hence I'm reluctant to change it.
I have now decided to manually split the order detail table, but when I create the query to re-join the fields back together, the database can't find a record in the attachments table with the matching orderdetail id when I try to add a new record. How do I set up the joining query so that a new record is created in the attachments table each time a new record is created in the order detail table?
Setup is as below:-
OrderDetailT
- ID (PK)
- OrderID
- Part Number etc
AttachmentT
- AttachmentID (PK)
- OrderDetailID (Linked to ID on the OrderDetailT)
- Attachment
I have the OrderDetailID in the AttachmentT as Indexed Yes (No Duplicates)
I thought that I did not require an AttachmentID field in the AttachmentT, but it is not working if I take this out either.
Thanks
