Lookup dash

Richard D. Williams richard at appgrp.net
Mon May 22 09:30:18 PDT 2017


On 5/19/2017 3:15 PM, Wayne Smith via Filepro-list wrote:
> Would somebody have an example of how to use the lookup -    my client
> would like to do multiple paged invoices and his business has grown so well
> over the years he asked me if I could make his existing 15 Item invoice
> continue to another record in the same file he is in and just add the usual
> stuff, name, address, city, etc in the free record and start him down in
> the area where he puts in inventory code.  (page 2)  with a bal.forward of
> course.
>
> The list has always been useful in the past and will look foward to trying
> anything....I can't seem to figure it out.
>
> Thanks ahead of time,
>
> Wayne Smith
> Port Orange, Florida
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170519/31bfd3e9/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
Wayne,

Sounds to me you need to change your file structure to a header/detail, 
instead of a set 15 item per invoice.

The lookup - syntax does allow you to get a new record within the same 
file and you could copy all the data
from this invoice# to the new record, clear out the 15 lines and move to 
that record in update mode.

The questions remains, is that really the best method to accomplish 
unlimited item son any invoice?

If you do not know how to create a header/detail I would be happy to 
show you.

Richard D. Williams



More information about the Filepro-list mailing list