Need to display data using with two join statement and substring.
Do I need to create:
1.Foundset and then load query in foundset and display in table view(non editable). I need to display only one field in form that too in formatted String. Thats reason I'm using sbustring in SQL query.
OR
2.Can I join table at design mode itself by creating relations with two table. Then how can I format the string. I don't know is which is the correct method to display data and how can I accomplish it.