Signature associated according to UserID

[vanny]

Hi all, hope someone can help me with this:

I have an Order Form that once all details are filled in, the user chooses to view the Preview (REPORT) of the Order.

I have a table called USERS where it stores the USERID thus it is able to configure who is logged in the database.

When clicking to view the Preview button of the Order, I would like that a parameter query pops up, asking the user whether he wants to include a scanned signature (the aim is to be able to export the Order into a Snapshot View and send it to the client immediately with the signature (jpeg)) and if yes enters his userid. Thus only the user who is logged in must have access only to his signature.

I created another table storing the SIGNATURES of the users, thus I included the UserId and Picfile (that stores the location of the picture).

On the Order Report I included a subreport storing the signatures.

Can someone suggest a way of how to proceed.

Thanks a lot.

 

[ted.martin]

How about adding the signature as a default and use the visible property depending on whether you want it shown or not?

 

[vanny]

Hi, can you explain further about such point, maybe using an example of how I can go about it, cause I am still new with certain functions...

Thanks a lot