Our zones and sections do not equal each other. I'd like to add zone_no to VS_TCK_HIST table, but I can't figure out how to link the T_TCK_HIST to a particular order_no or lineitem.
Also, does that unique TCK_NO link to any other tables?
Thanks,
Jan LaRocque
Houston Symphony