TIP: Click on subject to list as thread! ANSI
echo: paradox
to: BRET JOHNSON
from: DOUG BRADLEY
date: 1995-03-14 19:37:00
subject: Multi Record Dos 4.5 Help

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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.