Easy question for any successful user

[thesnowsnake]

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]

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]

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]

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]

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

screen1.gif (24.61 KiB) Viewed 3077 times

Then press feed back side tab:
and get this:

screen2.gif (37.55 KiB) Viewed 3077 times

I know there is feedback check this:

screen3.gif (23.14 KiB) Viewed 3077 times

The system seems easy but I must have missed something

Thanks Again

[shannah]

What happens when you click on jonathons feedback tab?

[thesnowsnake]

This is the tab I press :

screen 67.gif (24.52 KiB) Viewed 3073 times

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

screen66.gif (57.5 KiB) Viewed 3073 times

Don

[shannah]

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

[thesnowsnake]

OK sorry its the only one that had results:

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

new screen.gif (19.81 KiB) Viewed 3071 times

[thesnowsnake]

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]

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

[thesnowsnake]

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]

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.