This topic is locked
[SOLVED]

 "Where" in lookup wizard filter problem

1/6/2014 7:17:04 PM
PHPRunner General questions
A
andreas.knab author

Hi ,

i've just installed phpr 7 and I'm realy happy with it. I almost finished a Little learning solution for my Kids without programming skills.
now I'am at the Point where i got stuck.
I use the same Table for storing data and as lookup Table (as View) for the lookup wizard . This works fine but has one Problem.
I have a field for the Question Numeber 1,2,3,4,5 and so on.

Each question has 4 possible answers.
The Problem ist that in the Lookuptable (of the running app) I can see _all answers_of all questions.

When I select unique Values I have only the possible answers of question 1 for all of them.
I tried to adapt many code samples from the Forum, but I was not successfull.

Either I got an error or nothing happend.

I did a full build every time.
To be honest I have no idea what to do now.

I would really appreciate a code to assign the lookup question numbers to the regular table numbers (if that is the solution)

Help Please

Thanks

Andreas

Sergey Kornilov admin 1/6/2014

Andreas,
I guess we are going to need more info. Show us example of real data from your database, what WHERE clause do you use and what do you want to see in that dropdopwn box.
I can also add that using the same table as main table and lookup table is a wrong idea. They need to be two different tables.

A
andreas.knab author 1/8/2014

Sergey,

Thanks for the fast solution.
I misunderstood the way the lookup wiz. is working.
I created several lookup tabels now (make them dependent on each other) and it is working perfect.
I learned it from "Cars" where you did the same...
THANKS!!
Andreas