Well I think you are done. However, not certain all those fields are needed. Some were examples from some of the other approaches. I would think you only need (ID or AttachmentID). I assume that is an autonumber. I think the Vendor number is the foreign key to the related parent table so you need either one of those. So lets assume that you are using Vendor_FK. Then your form would have an attachment subform linked by the Vendor ID in the parent table to the Vendor_FK in the subform. Should be the exact same thing you use in your subreport to show your list. There was some code to take your existing attachments and move them out of the database and populate the table with the related information.
On Fri, May 30, 2014 at 5:43 PM, ka0t1c_ang3l <no_reply@yahoogroups.com> wrote:
These are the fields I have in my table:
ID
AttachmentID
AttachmentName
AttachmentTimeStamp
Parent_FK
Vendor_FK
The hyperlink field is the AttachmentName Field. In the subform I am manually entering the name of the document, and then I right click to edit the hyperlink and add in the location of the document.
__._,_.___
Posted by: Peter Poppe <plpoppe@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (27) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar