Page 1 of 1

PostPosted: Mon Nov 06, 2006 5:38 pm
by roginald
I have 3 tables:

projects
keywords
rank

the idea is to allow people to associate keywords with a given project, with each keyword having a rank, basically a number 1-10. After looking around it seemed the only way to accomplish this was to have the three tables and then a linking table with 3 columns for each repective tables id, and use joins. I managed to set up a dataface relatinship in the relationships.ini in the projects table dir. however am thinking dataface is not set up to handle this sort of set up without utilizing sql in the ini, if at all. Any help?

PostPosted: Mon Nov 06, 2006 5:49 pm
by roginald
nevermind, I am a fool. I forgot that i can just have another column in the linking table and keep traack of ranking that way, thus elimintating all this 3rd rank table nonsense. and it works with dataface. woohoo.