Assuming that you have this relationship between your two tables:
Employees::EmployeeID = Sales::EmployeeID
Perform a find on the Sales table specfiying "Active" in the Employees::Status field (use whatever value in status marks the employee as active.)
This will find all sales data that is linked to an active employee.
thank you for the reply. Could you give an example The two tables are related by employeeId..
I have two layouts. One is for adding customers that contains a drop down called Employee Name. In this drop down I want to show only active employees. How can I do that. if I create a value list it selects all the employees whether active or not.PreferencesPreferences
Will you be performing the find manually or in a script?
A script might look like this:
Go to Layout ["Sales" (Sales)]
Enter Find Mode  ---> clear the pause check box
Set Field [Employees::Status ; "Active" //I am guessing that the text "active" marks an employee as active ]
Set Error Capture [on]
Sort[Restore ; no dialog]---> I'm guessing that your chart will need the records sorted