"When I create a link to the JobProd table using company, ordernum,
and orderlin so I can pull in the job number.. may report doubles in
length."
The jobprod has a record for each OrderRel line. therefore, if any of your
OrderLine's have multiple release, there will be multiple JobProd records
(one for each release). Each release may also have a different quantity,
due date, so you should probably include this table as well to pull in that
information.
Sarah
and orderlin so I can pull in the job number.. may report doubles in
length."
The jobprod has a record for each OrderRel line. therefore, if any of your
OrderLine's have multiple release, there will be multiple JobProd records
(one for each release). Each release may also have a different quantity,
due date, so you should probably include this table as well to pull in that
information.
Sarah