General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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 ??
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only