Page 1 of 1

Easy question for any successful user

PostPosted: Fri Aug 26, 2011 1:31 pm
by 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: :cry:

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.. :roll:

Re: Easy question for any successful user

PostPosted: Fri Aug 26, 2011 4:04 pm
by 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.

Re: Easy question for any successful user

PostPosted: Fri Aug 26, 2011 4:50 pm
by 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"

Re: Easy question for any successful user

PostPosted: Fri Aug 26, 2011 7:29 pm
by 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 ... ??????

Re: Easy question for any successful user

PostPosted: Fri Aug 26, 2011 9:59 pm
by thesnowsnake
Ok I find the client Johnathon Tait (he has feedback 4 sure)

screen1.gif
screen1.gif (24.61 KiB) Viewed 3082 times


Then press feed back side tab:
and get this:


screen2.gif
screen2.gif (37.55 KiB) Viewed 3082 times


I know there is feedback check this:
screen3.gif
screen3.gif (23.14 KiB) Viewed 3082 times


The system seems easy but I must have missed something

Thanks Again

Re: Easy question for any successful user

PostPosted: Sat Aug 27, 2011 8:02 am
by shannah
What happens when you click on jonathons feedback tab?

Re: Easy question for any successful user

PostPosted: Sat Aug 27, 2011 9:35 am
by thesnowsnake
This is the tab I press :

screen 67.gif
screen 67.gif (24.52 KiB) Viewed 3078 times

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




screen66.gif
screen66.gif (57.5 KiB) Viewed 3078 times

Don

Re: Easy question for any successful user

PostPosted: Sun Aug 28, 2011 6:58 am
by shannah
Not the feedback table tab. The feedback relationship tab. It is one of the green tabs under the JONATHON heading.

Re: Easy question for any successful user

PostPosted: Sun Aug 28, 2011 7:52 am
by 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
new screen.gif (19.81 KiB) Viewed 3076 times

Re: Easy question for any successful user

PostPosted: Sun Aug 28, 2011 8:30 am
by 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.

Re: Easy question for any successful user

PostPosted: Sun Aug 28, 2011 9:08 am
by thesnowsnake
The basic seems to work ok but im reaching right now..Enjoy your weekend....Summers fadin...

Re: Easy question for any successful user

PostPosted: Sun Aug 28, 2011 2:16 pm
by 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)

Re: Easy question for any successful user

PostPosted: Wed Aug 31, 2011 7:12 pm
by 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.