Add New ____ record (relationship) Not working

A place for users and developers of the Xataface to discuss and receive support.

Add New ____ record (relationship) Not working

Postby 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
 
Posts: 3
Joined: Wed Aug 01, 2012 9:14 am

Re: Add New ____ record (relationship) Not working

Postby DiodeDave » Fri Aug 03, 2012 8:58 am

Opps :shock:

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.
DiodeDave
 
Posts: 3
Joined: Wed Aug 01, 2012 9:14 am


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 38 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved