Project 2 Safe Purchase automation processing. Nov 20, 2020 by Ray Grace

Project 2 Safe Purchase automation processing. Nov 20, 2020 by Ray Grace When a Member reports a safe purchase the complete a form. Vendor website Amount Cart Log in Id Password SUBMIT This goes into a table with these fields SP number User_ID Parent_user_ID date time plus the info above. All tables are linked with the user_id field. We have a table that calculates the Member account Balance. User_id email address First Name Last Name This info comes from the user_profile table Once they have submitted a Safe Purchase the first thing we do is see if you have the funds. If No Then: Send a Secure Message and a popup on the screen. “Funds unavailable. Pease make a payment.” “Safe Purchase cancelled.” “Please resubmit after payment is confirmed”. If Yes Then: Check to see if the Member is a dependent. User_id has a field called parent User_ID. If this field doe not equal user_id Then change the delivery person and address to the Parent. Debit the Member account for the funds and make the Safe Purchase. Once the Safe Purchase is complete send a Secure Message with the invoice for the Safe Purchase to the Member and if necessary the Parent. Log off the Members Shopping cart. I NEED A PASSWORD PROTECTED TABLE THAT IS SORTABLE andcan be restricted by form date to date and BY ALL OF THE FIELDS. I must be accessible by multiple WebPicID employee users with an ID and Password from the website. Most of this may be in place I have not checked. Ray Grace