Easy question for any successful user

Archived from the Xataface Users forum.

thesnowsnake — Fri Aug 26, 2011 1:31 pm

I have two tables .

A: client (big Source)

B: Feedback (Many to one)
This is my relationships.ini in the client directory.

[feedback]
feedback.client_ref = “$Idclient”

This Is what I used and It fails:

Is it because the field in the feedback table must be exactlly the same as the Primary Index field in the client table?? like
so:
[feedback]
feedback.Idclient = “$Idclient”

Just a question before I change the main database tables..

shannah — Fri Aug 26, 2011 4:04 pm

When you say “it fails”, what happens? (e.g. error message).
That syntax looks ok if you have a client_ref field in your feedback table which contain ids of client records. And your client table includes an Idclient field.

Note that everything is case sensitive.

Is it because the field in the feedback table must be exactlly the same as the Primary Index field in the client table??

All that is necessary is that your stated condition is true. I.e. That relationship will contain records from the feeback table having client_ref equal to the Idclient field of the source client record.

thesnowsnake — Fri Aug 26, 2011 4:50 pm

I see nothin in the feedback table after the grid displays the correct client.

I have checked spelling and caps.

This is the actual relations.ini from cliect directory eg:
/public_html/XXXXXXX/tables/client

[feedback]
feedback.client_ref = “$Idclient”

shannah — Fri Aug 26, 2011 7:29 pm

relations.ini

Do you mean relationships.ini?

I see nothin in the feedback table after the grid displays the correct client.

Can you elaborate on this? Do you click on a client in list view and see a blank screen? Or do you see the client details, then click on the “feedback” relationship subtab where you see an empty list, or … ??????

thesnowsnake — Fri Aug 26, 2011 9:59 pm

Ok I find the client Johnathon Tait (he has feedback 4 sure)

Then press feed back side tab:
and get this:

I know there is feedback check this:

The system seems easy but I must have missed something

Thanks Again

shannah — Sat Aug 27, 2011 8:02 am

What happens when you click on jonathons feedback tab?

thesnowsnake — Sat Aug 27, 2011 9:35 am

This is the tab I press :

And this is what I see (looks like all the test fields)

Don

shannah — Sun Aug 28, 2011 6:58 am

Not the feedback table tab. The feedback relationship tab. It is one of the green tabs under the JONATHON heading.

thesnowsnake — Sun Aug 28, 2011 7:52 am

OK sorry its the only one that had results:

Listen I can change the names of the feedback fields at this point..(FYI)

thesnowsnake — Sun Aug 28, 2011 8:30 am

OK maybe I have the files inthe wrong place.

I have main program in public_html/dataface/dataface/Etc
And my relationships.ini and fields.ini are located in:

/public_html/IouGuy/tables/client

Does this look ok. I changed it from the original /public_html/iouguyc1/
then created tables etc.

thesnowsnake — Sun Aug 28, 2011 9:08 am

The basic seems to work ok but im reaching right now..Enjoy your weekend….Summers fadin…

thesnowsnake — Sun Aug 28, 2011 2:16 pm

OK now I duplicated all files back into the original. still no luck hmmm maybe a fresh start..

What do you think?

I maybe made a simple mistake..(It’s possible LOL)

shannah — Wed Aug 31, 2011 7:12 pm

No need to start fresh. Your sticking point is the relationship. Clearly the query defined in the relationship definition yields an empty set for that record for some reason. You should investigate that and only that.