Viewing 4 posts - 1 through 4 (of 4 total)
No can do. Not all order types have a sub type so not all order types will be in the sub_type table. Therefore, I need the order_type foreign key to...
March 2, 2007 at 7:32 am
Thanks, Stephanie. I realized that when I tried implementing the trigger. I think the sql I'm going to go with is:
March 1, 2007 at 8:18 am
Thank you - I think that should work. Here's my table structure, which hopefully explains why a simple foreign key isn't enough.
Order_Master - contains all order fields including order_type_id (int)...
March 1, 2007 at 7:37 am
How would that help? Then I'd be assigning multiple values to a single variable.
February 28, 2007 at 1:08 pm
Viewing 4 posts - 1 through 4 (of 4 total)