Hi,
I have 2 tables:
1. Application
2. Users
I need to do a count of applications per user. In the Application table I have a field 'SalesAgentID'. I need to link this to the field 'AgentID' in the Users table in order to display agent name which is held in the Users table. The problem is that every time an agent views or edits a particular application, their ID is written to the SalesAgentID field so you can end up with multiple ID's in this field.
Is there any way of saying 'Look at the first 7 chars in the SalesAgentID field, match this with the AgentID field and display these first 7 chars along with agent name held in the Users table?
Thanks
I have 2 tables:
1. Application
2. Users
I need to do a count of applications per user. In the Application table I have a field 'SalesAgentID'. I need to link this to the field 'AgentID' in the Users table in order to display agent name which is held in the Users table. The problem is that every time an agent views or edits a particular application, their ID is written to the SalesAgentID field so you can end up with multiple ID's in this field.
Is there any way of saying 'Look at the first 7 chars in the SalesAgentID field, match this with the AgentID field and display these first 7 chars along with agent name held in the Users table?
Thanks