related records relationship problem

Archived from the Xataface Users forum.

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 — 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