related records relationship problem

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

related records relationship problem

Postby cookie720 » Tue Jun 19, 2012 7:53 pm

Hello all,

When creating an new order record, and selecting a client ID from a drop down i have (or creating a new clients record by clicking "other....") I cannot see the newly created client in my related records of my orders table. Thus, I can only see a client if I create it by clicking "add new clients record" in the related clients tab.

Is this a bug of some sorts??

my relationships are crossed over so clients relationships.ini has
[orders]
orders.ClientID = "$ClientID"

and orders relationships.ini has
[clients]
clients.OrderID = "$OrderID"

the reason for this is so that i can look up what orders my client has, and look up what client is on a particular order
cookie720
 
Posts: 69
Joined: Mon Jun 04, 2012 9:22 pm

Re: related records relationship problem

Postby cookie720 » Tue Jun 19, 2012 9:24 pm

OK i switched around
[clients]
clients.OrderID = "$OrderID"
to
[clients]
clients.ClientID = "$ClientID"
in my orders' relationships.ini

and that fixed my problem.

in my clients relationship.ini:
[orders]
orders.ClientID = "$ClientID"

I also deleted orderID from clients as that is a no no
cookie720
 
Posts: 69
Joined: Mon Jun 04, 2012 9:22 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 9 guests

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