2. PHPRunner General questions
  3. Use Custom View as Lookup
This topic is locked

Use Custom View as Lookup

 		4/30/2009 2:27:30 PM
PHPRunner General questions
lewisgr author

Can you get a Custom view to be a lookup field? This would be great if someone said yes and told me how to do it.
Thanks
J
 		Jane 5/4/2009

Hi,
unfortunately PHPRunner do not support custom view created in PHPRunner directly as lookup tables.

You can create this view in the database and use it on the "Edit as" settings dialog on the Visual Editor tab.
lewisgr author 5/4/2009

I found what I needed I should have posted back.
I just use the table where the view came from and had Access help me create the SQL code needed for the WHERE condition. Works great! Thanks for the reply.

Hi,

unfortunately PHPRunner do not support custom view created in PHPRunner directly as lookup tables.

You can create this view in the database and use it on the "Edit as" settings dialog on the Visual Editor tab.