Joins

[keith21]

Hi
Is there any way to do more than one join. I have four tables Service User, Ops Manager, Property and staff. The service user table is joined to the property table, which then looks at the ops table. For some reason after doing more than one join fabrik picks up the id number that then get displayed in form. How do I over come this, rather than showing just the id number it should displays the staff name. Can someone please help as I need to get this project completed soon. Thanks

 

[keith21]

please see images for the output. On the database join can I ref another table or something or do a join so it pick up the id and name. Really need help on this.

thanks in advance.