Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Where's my relationship ??
Message
De
12/12/2001 03:42:35
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00593120
Message ID:
00593132
Vues:
20
>>I have two tables.
>>An article-table and an catagory-table.
>>The article table has an primary key on his articlecode and a regular on the category-id.
>>The category-table has an primary key on his id.
>>In the forms dataenvironment I see there's a relationship bewteen them,
>>but when I'm running the form and moving to the next record of the article table, the category table stays at the same record.
>>What am I doing wrong ?!?! :-(
>First, see to it that the child is the category and the parent is the article table. Second, the width of the key fields should be the same.

There is no child or parent, each article has an category with settings specefic for that category (rates,...).
A category can be assigned to multiple articles.
If I go to an article I want to see the category's rating and use this to calculate his price.

I think my problem is I made the wrong indexes.
Article-table -->PK ->article-code
Regular ->category-code

category-table -->PK ->category-code

Are this the right indexes ??
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform