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