Page 1 of 1

Many-To-Many Relationship assistance

PostPosted: Mon Nov 22, 2010 10:21 am
by digital1
Hi,

I have 2 tables, show and host. I also have a table called host_show that houses the keys between the two tables. I have the following code in the relationship.ini file for host:
Code: Select all

[host]
users.id=  "$updatedId"

[show]
show.id=host_show.showId
host_show.hostId="$hostId"



I am not getting the UI changes as expected. Any ideas? Thanks in advance!

Re: Many-To-Many Relationship assistance

PostPosted: Mon Nov 22, 2010 10:46 am
by shannah
Change the name to relationships.ini (not relationship.ini)

-Steve

Re: Many-To-Many Relationship assistance

PostPosted: Mon Nov 22, 2010 11:00 am
by digital1
Wow... I feel dumb. LOL! Thanks Steve again for a quick response. This makes me wonder though... Throughout my application I have used relationship.ini to define my foreign keys. It works as it should I think. It's not crashing. Does this mean I should change all of my files to be relationships.ini? Also I saw a few previous posts about primary keys and denoting those in the relationships.ini so that adding records will work. Does this apply across the board?

Re: Many-To-Many Relationship assistance

PostPosted: Mon Nov 22, 2010 11:11 am
by shannah
Yes. Xataface doesn't look for any files named relationship.ini ... they just get ignored.