Creating a relationship

[blange]

I'm a xataface newbie trying to create my first relationship. I have a one to many relationship between Categories and Services. I thought all I needed to do was to go into /tables/category/relationship.ini and add

[Services]
service.category_id = "$id"

The primary key in the Categories table is 'id'. Am I doing something wrong? Is there any kind of cache I need to delete?

Thanks,

Brian

[shannah]

I suspect that your problem is to do with table names.

E.g. you mention that the relationship is between tables named "Categories" and "Services". Yet in your relationship you are referring to a table named "service".

[blange]

My tables are lower case "service" and "category".
Should I be getting any kind of error message? I don't seem to be.

By creating the relationship I am hoping to see the Category Name when in the "List View" for Service.
Is this what should happen?

[shannah]

You won't see the relationship in list view. In details view, you should see an additional tab for your relationship. "View", "Edit", and now "Services"

[blange]

I do see it. Thanks for the help!