I am trying to create a sched. shipments by planner, very much like the
scheduled shipments report that comes with Vantage. I started off with the
orderdtl table where 75% of the information is contained. Without any
filters yet to exclude closed lines or whatever there may be.. I get 17
pages. 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.
Any suggestions on why? I attempted both types of joins, which does not
have any effect.
Thank you,
Greg
scheduled shipments report that comes with Vantage. I started off with the
orderdtl table where 75% of the information is contained. Without any
filters yet to exclude closed lines or whatever there may be.. I get 17
pages. 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.
Any suggestions on why? I attempted both types of joins, which does not
have any effect.
Thank you,
Greg