2. PHPRunner General questions
  3. lookup wizard problem
This topic is locked

lookup wizard problem

 		7/19/2006 09:53:51
PHPRunner General questions
kujox author

Hi
I Seem to be having a problem in the lookup wizard, i can choose the table but it does not allow me to select the values, they are just greyed out, it seems ok on other tables it's just this 1 table.
I only have 2 fields in the dropdown table, id and name
Any ideas?
J
 		Jane 7/20/2006

Hi,
thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update.
To make your project working please change your table name to __Tablename.
kujox author 7/21/2006

Hi,

thank you for pointing me to this bug.

We'll fix it in the next PHPRunner update.
To make your project working please change your table name to __Tablename.


jane,
That didn't work, what I did was using phpnyadmin, I exported the table, changed the table name and then ran the sql to put back the table and data. It's the same as before.
After a play about, it seems to be if the master/detail is set, it doesn't allow a lookup of the master, so if I wanted a another form of entering the data(table view), say to edit a line in the detail record and change it's master.
Any idea on a workround?
Alexey admin 7/21/2006

Hi,
I recommend you to create a custom view for your detail table.

Remove master-detail relationships from this view and use it to edit Master ID field.
kujox author 7/23/2006

I recommend you to create a custom view for your detail table.

Remove master-detail relationships from this view and use it to edit Master ID field.


That didn't work, the custom views don't appear in the lookup wizard, is that correct?
i'm going to use a duplicate table and just use that for the lookup until the next release
Alexey admin 7/24/2006

Hi, I'm sorry I wasn't clear enough.
Create custom view for your detail table, remove master-detail relationships from this view.

Proceed to Formatting tab for this view, choose Edit as - Lookup wizard for Master ID field.

Choose Mastertable as lookup table, fill in the rest of fields.
Build the pages and use this custom view to change the record's master.
kujox author 8/8/2006

Hi, I'm sorry I wasn't clear enough.

Create custom view for your detail table, remove master-detail relationships from this view.

Proceed to Formatting tab for this view, choose Edit as - Lookup wizard for Master ID field.

Choose Mastertable as lookup table, fill in the rest of fields.
Build the pages and use this custom view to change the record's master.


Alexy,
I have found a quick fix to this problem, I just made a dummy table "_aaa" so it sits at the top of the table list, now this table is the one that I am unable to use as a dropdown and the other works fine.