Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement