In Crystal you can link the BOLHead.BOLNum to the ShipHead.ShipLog in the
visual linking screen. Accept the error that tells you the fields are
different types and exit. Next go to Database and Show SQL Query. Edit
BOLHead.BOLNum to show string(BOLHead.BOLNum) and it should work fine.
Michael
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
visual linking screen. Accept the error that tells you the fields are
different types and exit. Next go to Database and Show SQL Query. Edit
BOLHead.BOLNum to show string(BOLHead.BOLNum) and it should work fine.
Michael
> -----Original Message-----http://groups.yahoo.com/group/vantage/files/.
> From: esmalley@...
> [mailto:esmalley@...]
> Sent: Tuesday, September 25, 2001 4:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Bill of Lading - Adding packing slips
>
>
> Darren,
>
> In 3.0 the link was bewteen the BOL # and the Log field on the Pack
> Slips. The BIG problem is the BOL # is numeric and the Log field is
> alphanumeric which make it impossile to link them in Cyrstal or
> Report Builder. As I recall in testing 5.0, nothing had changed.
>
> Erik Smalley
> IT Manager
> Milford Enterprises Inc.
>
> --- In vantage@y..., Darren Mann <dmann@m...> wrote:
> > Is there a means of linking additional packing slips to a
> previously created
> > BOL?
> >
> > Is there a way to print linked packing slip #'s on BOL? I can not
> find a
> > link between the data structure to create the needed report and of
> course
> > they are not included in the .dbf files for the BOL report.
> >
> > Is anyone else tired of the slow delay to search for BOL's? This
> has been a
> > problem since 3.0 but nothing gets done. This area of the program
> could use
> > a lot of revamping but apparently it is not used by the larger
> Vantage
> > users.
> >
> >
> > Thanks for any assistance.
> >
> > Darren Mann
> > Miller Products Co.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to
> enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/