BJ>I am having a problem. When, I have more than one Describtion, Units
BJ>and KG Weight. How can I be able to see all the Describtions, Units
BJ>and KG Weights?
.
.
BJ>The lading can have more than one PO Number. I mean each description
BJ>will have a different PO Number and the Units will be different as
BJ>well as the KG Weight will be different as well..
.
.
BJ>As you can have more than one PO Number per Lading you can not key
BJ>it..
You might try adding a field of Type N called e.g. Line_number to
your proposed embedded detail table. You'll have to add code to
increment this number for each addition item ( don't forget to handle
line insert & line delete cases ).
You can then have a composite key of PO Number + Line_Number enabling
you to embed
---
* CMPQwk #1.42-20* UNREGISTERED EVALUATION COPY
--- QScan v1.141b / 01-0120
---------------
* Origin: (1:221/206)
|