> Hello ALL,
 > I am having a problem.  When, I have more than one Describtion,
 > Units and KG
 > Weight. How can I be able to see all the Describtions, Units and
 > KG Weights?
 > The Lading Table looks like:
 > Lading # A5
 > PO Number A5
 > Customer # A8
 > Name A30
 > Address A30
 > Address #2 A30
 > City A12
 > State A2
 > Zip Code A10
 > Special Instructions A40
 > Date D
 > Carrier A10
 > Freight Fees A7
 > Descriprion A30
 > Units N
 > KG Weight N
 > This table has these lookup tables:
 > Carrier
 > Customer
 > Description
 > Freight
 > The lading can have more than one PO Number.  I mean each
 > description will
 > have a different PO Number and the Units will be different as well
 > as the
 > KG Weight will be different as well..
 > How can I set a form (That I can use for dataentry, Viewing and
 > printing)
 > to show what each Lading # has?
 > I tred to make a templading table with just the Description, Units
 > and KG
 > Weight in it but you have to key it to be able to place the multi
 > record
 > form onto the master table form.
 > As you can have more than one PO Number per Lading you can not key
 > it..
 > Can anyone help me?
 > THANKS!!!
Sounds like a database description problem to me, Bret, trying to figure out 
what is related to which.  I take it that one lading number can be associated 
with several PO's, but is the relationship of each PO to description, units 
and kg weight 1:1?  If it is, then you might want to consider multiple 
tables, since the relationship of items within a single table really has to 
be 1:1.
You could have one table that has lading # and PO# as a compound key,
with a second table that has PO and the associated data,
with PO # as the key.
Rich
---
(1:125/9)
---------------