Xataface Forums

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

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.