Hello,
I have been working on several projects aimed at reducing the number of anonymous, general admission, and constituent 0 orders in the system and I have found a way to gather email address and order numbers independently, but now I need to attach them in the system.
What I would like to do is call a procedure that will look up the order number and write in the correct constituent from a local table. Has anyone written a procedure to do this? I am assuming this is more involved than just updating T_ORDER.constituent_no. Can anyone tell me what all I would need to touch or what procedure system calls when you key it from the front end?
Thanks in advance.
SADIE PRATER
Systems Analyst
Perot Museum of Nature and Science
> I am assuming this is more involved than just updating T_ORDER.constituent_no.
You can move an order from one customer_no to another with just that update, yes, as happens e.g. during a merge. (Don't forget T_PAYMENT, too, though.)