kebhin

Hi Peter,

It looks feasible – I will have to get to grips with Code Manager for the first time but I’ve seen the documentation.

What about the second use case – having a textarea element for a specific sql data type (e.g. mediumtext)

Thanks again

Hi Peter and anyone monitoring this thread,

This issue was fixed and autocomplete is working for me as of release 5.2.5

Thanks again for your excellent support

Hi Peter

That looks good. I am just finalising a release of my site and once that is deployed I will upgrade my development to 5.2.3
A question occurs to me about the use of the function in views. If I’m logged in as an admin user, go into Data Explorer and create the view as documented, does that mean when logging out and logging back in as a normal user that the view will work as expected (i.e using the currently logged in user id)?

Best regards
Kebhin

Thanks Peter that is fantastic news and will really enhance the possibilities managing relations in WP Data Access

Thanks Peter, but I don’t think dynamic conditional lookup does it. This depends on creating a view that can filter the condition I’m looking for.
Actually the view concept is very simple – it would be

create view listbox as select member_id,member_name from members where group_id=$$USERID$$

But of course I can’t use $$USERID$$ in a view definition

Essentially I need to get a variable that is not stored in the database as part of the view or listbox condition. If I could somehow get 2 columns (group_id+member_id) into the Source column name of the relationship that would also work