Hi

I'm not sure if this is a bug or not, but I noticed that when I try to pull Joomla username to a view through a foreign key reference, that reference joomla user id, then the combo that would list the user is empty.

Let me try to explain the setup.

Table 1: User data

Reference to Joomla user data

Table 2: Time sheets

Foreign key to Table 1: User data

My Table 2 Page:

I pull username through User data -> User->Username

This renders an empty combo box.

If I design Table 2 to reference Joomla user directly then it works fine, but then I don't have the reference to Table 1 with my additional user info which is not good in my case.

Is it a bug?

Is it in V2.0, or 1.5 ?

I cannot see this one. Many post have related to this. But seems fixed now :
www.j-cook.pro/forum/18-closed-tickets/4...-users-in-combo#4140

Another issue again ?

This was in 2.0 beta
I don't this issue is fixed currently - at least not in my particular case.

I got that one the other day in V2 and cured it by removing the FK to users, refreshed page, added again. Worked fine in sandbox and local thereafter!

Gez