I have a form that has an employee no in the associated table of the form, I want to display in a tabular form the employee’s full name. How do I define the SourceExpr such that it calls the function FullName from the employee table to display the correct employee name[?]?
You can put in SourceExpr function (for example GetEmplName(EmployeeNo)) that returns full name of employee. Full name of employee you can get from Employee table.
Arthur, works perfectly. I call a function within the form with the parameter of the employee no. that is within the table associated with the form and get the employee record, call the fullname funtion and return that to my form. Thanks![:)]