I need to display records from two table employees and department in table view based on relation
I want to display deptarment id and deptartment name in table column together. Like
10 - shipping
20 - Purchase
30 - Packaging
goes on…
How can I accomplish. Do I need to go with dataset or need to say -
foundset.employee_to_department.dept_name= employee_to_department.dept_id + " - " + employee_to_department.dept_name
foundset.loadallrecords()
Please suggest
The best option is to create a valuelist based on the department table. It should show the 2 fields and return the department_id. Create a field with the department_id from the employees table, attach the valuelist and change the display type to combobox or typeahead.
Another option is to use a calculation, but that makes it more complicated to edit the field.
Thank you Joas
I don’t need to edit table view its read only. When user double clicks on particular record it should open detail page and does editing.
Its preferable to go with calculation so that conbined field is displayed in text field.