BJ>I need to come up with a Bills of lading program in PDOX 4.5 DOS
BJ>I had two databases one had all the customer and ship too info in it.
BJ>The other had all the part information in it.
.
.
BJ>As you all know and "I should have" that any Bills of Lading may have
BJ>one or more entries on it!
BJ>I can not get a mutli record form to work  here.
Bret - my 2 cents worth
BJ>2,  What do I need to do to get this working?
        - recommend two (2) more tables perhaps named 'shipments' and 
'shipped' .
        - the former to track customer name address info at time of 
shipping ; while perhaps non critical, the customer's name or ship to 
info will/may change over time in the master 'customer' table. This 
table will contain info to meet your requirements AND a field named ,say 
"BL_No" ( perhaps of type A10 > to hold a unique bill of lading number.
        - the shipped table will have a structure including the first 
two fields of ...
                 [BL_No]     A10*
                 [Item_No]   S*         ( you won't need over 30000 ?)
        
        plus appropriate other fields for information describing what 
was shipped and to facilitate using your present part information table 
as a look up & fill table  (you may also want other look & fill tables 
available such as NMFC item # nomenclature; Haz Mat stuff etc ) 
        Creating a form now with shipments.db as master and shipped.db 
as a multi record embedded should be no fuss ( remember that the field 
"BL_No" can not be on the form you create for the embedded detail table 
as it is the linking field ).
        This should get you over the multi record hurdle. One thing you 
will have to do is to manage the incrementing of the [Item_No] field - 
for each line of product shipped - to maintain a unique composite key in 
the detail table (B/L_No+Item_No.)  i.e. numbering each detail line 
sequentially as entered will be required . DO NOT use RECNO() for this ( 
think about what would happen on inserting a new record between 2 
existing records ) !  
        Oh yeah - displaying weight & piece totals on screen will be a 
PITA ! 
---
* CMPQwk #1.42-18* UNREGISTERED EVALUATION COPY
--- QScan v1.141b / 01-0120
---------------