One catch that came to my attention. If customer sees the codes onscreen at Paypal, how to insure that they do not try to cheat the system and use without paying?
Maybe use the pp post to update the items payment status for each item in the orderdetail table, for that the order? I am not sure how to setup that type of update table server behavior so that it will look for each item purchased and write to that column. If that sounds like an idea that would work, it can set upanother value "" but, please sugest how to config the update behavior.
A better way to eliminate the issue is to some how confirm payment when pass is activated against the payment status of the item? Use SecurityAsssit Authenticate User with the order status=payed value as an extra field to compare for validation? Or can the authenication check two tables for the access codes in the detailorder table for that item and in the order table where the pp already posts the payment status correctly?
Please & Thank you.