bontemuis
Member
I have two tables with a 1:1 relationship: Profile* and AdditionalInfo**. I made a LEFT join from Profile (id) to AdditionalInfo (prf_id).
The prf_id element is a databasejoin which displays Name from the Profile. In the 'Add option in front end' tab I set 'Link to the joined record' to Yes to (hyper)link Name to Profile. The AdditionalInfo List looks like: Name (join), Field1 etc.
Question 1: what do I need to do to also display Company in the AdditionalInfo List? I guess I don't need to add another databasejoin, do I?
Question 2: if I do a CSV export, the Name field shows either the 'id' or a url link to Profile. How do I get the actual Name value?
*Profile: id, Name, Company etc.
**AdditionalInfo: id, prf_id, Field1, Field2 etc. I want to change this to: id, prf_id, Company form Profile, Field1, Field2
The prf_id element is a databasejoin which displays Name from the Profile. In the 'Add option in front end' tab I set 'Link to the joined record' to Yes to (hyper)link Name to Profile. The AdditionalInfo List looks like: Name (join), Field1 etc.
Question 1: what do I need to do to also display Company in the AdditionalInfo List? I guess I don't need to add another databasejoin, do I?
Question 2: if I do a CSV export, the Name field shows either the 'id' or a url link to Profile. How do I get the actual Name value?
*Profile: id, Name, Company etc.
**AdditionalInfo: id, prf_id, Field1, Field2 etc. I want to change this to: id, prf_id, Company form Profile, Field1, Field2