Hi,

I have table employee (EmployeeBO) with field

employeeNo, employeeName.



I have txn table sale (SalesBO) with field

SalesNo, Date, EmployeeNo, Qty, Price, Total



I would like like to list table employee in editable GridView with columns



SalesNo, Date, EmployeeNo, EmployeeName, Qty, Price, Total



In order to achieve this, I added custom bindable field - EmployeeName to SalesBO, and retrieve it from employeeTable whenever required. I found that it is really killing my application performance.



May I know how should I amend it to get back performance?



Thank you

Oh, sorry, in my case I never update the FK description field, just RO, but all other fields are modifiable.



If you need to modify the Employee Name in that case probably you will need a view, I have not done that so I cannot advise you on that.



I am sure somebody will chime in here for the view or other method to get it done.

Edhy Rijo