Add New __ record (relationship) Not working

Archived from the Xataface Users forum.

DiodeDave — Fri Aug 03, 2012 7:53 am

Hi All,

I am working on my first Xataface front end. I have a relationship setup between two tables. The related data shows correctly. If you choose “add new record” the page switches to add new record. The Related field is not shown (which makes sense). After adding the data, when you click save. The record is not created???
It is probably something dumb on my part. Any suggestions would be appreciated.

Code: Select all

`MySql Database

• Cu (table)
    JobNumber int(25) PK
    other fields…

• Jobs (table)
    JobNumber int(25) PK
    other fields…

tables\Jobs\relationships.ini
[Cu Plate Log]
sql = “SELECT * FROM cu WHERE JobNumber=’$JobNumber’”`

Thanks in advanced.
David

---

DiodeDave — Fri Aug 03, 2012 8:58 am

Opps

It looks like I found the problem. In an older post …

In the “relationship.ini” file I used spaces between the words when I identified the relationship. That is a big No No.