Problem with Linking Tables

vanny

Registered User.
Local time
Today, 15:36
Joined
Feb 18, 2006
Messages
76
Hope anyone can help me with this!!

I have a Form where the user inputs the Order and associated with the Order I want to create another form able to let the user choose his Signature.

So I have a Table called Orders and a Table called Signatures. How can I link them together? In the table Signatures I included a primary field : SignId and then two other fields being : OrderAuthor (the name of the user who inputted the order) and PicFile (which stores the link where I filed all the user's Signatures)

When the Order is inputted the user is then able to choose the Preview and the Signature and everything is shown on a Report.

The aim of this report is to let the user email the Order Form with the Signature without have to Print the Order and Scan it and then send it to the Client.:confused:
 

Users who are viewing this thread

Back
Top Bottom