Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help! Relation gurus! ....
Message
 
 
À
17/05/1999 18:43:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00219833
Message ID:
00219963
Vues:
17
>I THEN set a last relation from the Inventory file to the Inventory Supplier file on the Item. So far, no problem. I can see the Vendor # on the Supplier file. HOWEVER, there can be (and are) more than one supplier for each Item. So I SET SKIP TO on the Supplier file. BUT, I only ever see one Vendor for each Item .... what do you think I'm doing wrong?
>

The order of the Supplier table is something like SupplierID? Then from Inventory, you SET RELATION TO SupID INTO SUPPLIER? I do not see how you could possibly see more than one supplier per item because your inventory item has some foreign key reference to the supplier. You will have to devise a scheme to actually display all the suppliers for a particular item, perhaps a 3rd table between the inventory and supplier tables. You would relate by item number from inventory to the middle [3rd] table, then by supplier id from the middle table to the supplier.

This means your middle table has an ItemNo record for each supplier of that item. This table would have 3 fields -- a surrogate PK, item_no and supplier_id.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform