Originally Posted by
kosan
I have a table named serviceCall that has a many-to-many relationship with a table named employee through a table named employeeServiceCall that stores the employeeId and the serviceCallId both combined comprise the primary key of the intermediary table employeeServiceCall.
I have 2 questions,
first,
When a user uses the form frmServiceCall to insert or update a service call how can I retrieve the amount of employees involved in that specific record as a number and store it in a field named amountOfEmployees located in the serviceCall table in order to use it for future processing?