0

I was wondering if anyone out could help me with a problem I'm having.

I have been asked at my job to set up a purchase order database and one of hte things they want is when a purchase order form is filled out, instead of the data going into the table datasheet, it is emailed onto the manager where he can approve the purchase order which is then sent back to the database.

To make matters worse, I've no experience with programming code so I don't know where to start with this problem.

Any help would be appreciated.

Regards.
Phive.

2
Contributors
3
Replies
6
Views
9 Years
Discussion Span
Last Post by MidiMagic
0

You need two tables. One is for the temporary file sent to the manager. The other is the permanent table, under the control of the manager. The manager then merges the record into the main table.

0

You need two tables. One is for the temporary file sent to the manager. The other is the permanent table, under the control of the manager. The manager then merges the record into the main table.

That's a good idea that I never actually thought of. Thanks.

But I was wondering do you know how to make the email that will be sent with the approval button embedded into it, kinda like the one's you get when you register for a forum and it asks you to activate the account. Something along those lines, if you get my drift.

0

You don't send an email with a button.

You send the temporary file to the manager as an attachment. Then the manager does the appending.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.