Many-To-Many Relationship assistance

Archived from the Xataface Users forum.

digital1 — Mon Nov 22, 2010 10:21 am

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!

---

shannah — Mon Nov 22, 2010 10:46 am

Change the name to relationships.ini (not relationship.ini)

-Steve

---

digital1 — Mon Nov 22, 2010 11:00 am

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?

---

shannah — Mon Nov 22, 2010 11:11 am

Yes. Xataface doesn’t look for any files named relationship.ini … they just get ignored.