Save user Name and email as values in a database join field

[witchypaws]

I have a table that gets the value of one field from the UserID in Joomla xfco_specialists___spec_name

It is storing the id number in the datatable rather than the value

Then I am trying to get that value from that table in another table via a database join and all I get is the value

Is there some way to store the user Name and Email (2 different fields) in the first table as values not id numbers using the User element or do i need to do a calc element here in stead

That way when I look for the name in the second table, i see the name not the user ID

Thanks

 

[Nagtegaal]

I guess that is the same question as your other post

 

[witchypaws]

HI Natlegal

No, this was a different question, it was asking about using the userid element was returning a number value in the database so joining it in the next table didn't work, however, I worked it out by using a standard field and putting eval code in the default section

Thanks for replying though

 

[akelot]

May be so
Plagin element - field
In the Default field for email- {$ my-> email}
for the user - {$ my-> username} or {$ my-> name}
Read only - Yes

 

[troester]

The sense of a dbjoin is storing the id/key.

To get the "original" labels of a join of a join use "or Concat label"
http://fabrikar.com/forums/index.php?wiki/database-join-element/#or-concat-label-examples