I have a select box (ajax loading) which pulls in info from a joomla user field in a foreign table.. something like this

Manager (Managers)
- Account (Users)
--Name

The name is coming through as the Joomla ID and not the actual name.

This infomation comes through correctly on GRID layouts

I have work arounds so not critical, just a minor observation

Project : RT Callout
Table : Rotas
Working View : Rotas (collection)
Broken View : On Call Rota (item) -> see Manager select box

I see.

This is not possible with Cook.

To reduce the description simplier : (You do not need to involve AJAX groups to raise the problem)

Make a simple FK in a form wich to refers to an account, itself referring to a Joomla user (double FK)

The result shown in the form will be the ID of the account, because cook does not accept more than one level deep for the labels in form combos.

This is interresting because I never had this case, and it can be usefull sometimes. But it becomes really complex to code. Good challenge.

It would be a new functionality, but I put it in pending tickets, because Cook is not supposed to limit deep levels when context allows it.
When you drop a sub/sub/sub... node in a form, it already reduce it to the base (which is normal from the context), but it should keep the choosen node for its label.

Right ?

This is what I was doing, I was just trying to streamline the process, its not important. I will go back to the adding name as a string in managers and just referring to the Joomla Account for linking purposes which works fine!

Enjoy the challenge if you do decide to accept =)

I am just excited by seeing Module and Plugin in new projects.... those are far more important. Still not written a search plugin for a Jomola 3,.2 component yet (big changes form 2.5 method)