Hi everyone,
I have Telemarketing team working from a Fe and BE database. Besides following up existing records they come across the situation where our call centre gives them new inbound leads. If they make a sales, they enter the record. So far they used a fake ID "99999" they constantly overwrite. By adding an after event to Order=Yes I kept track of sales made.
Now this gets messy and my question is what is the best idea to correct this?
The set-up is:
tblExternalList has basic field such as address, name etc. plus ID as PK
tblExternalList_enhanced has above field plus add. all call info
tbl External List and tbl ExternalList_enhanced are in a 1-1 relationship on field ID
Form is bound to a qry which has field from ExternalList and ExternalList_enhanced
What is the best way to get the functionality that an agent can add a new record each time they need to??? I wanted to ask this before fiddling around with autonumber etc.
Many thanks for anyone who can give me some good advice
Regards
I have Telemarketing team working from a Fe and BE database. Besides following up existing records they come across the situation where our call centre gives them new inbound leads. If they make a sales, they enter the record. So far they used a fake ID "99999" they constantly overwrite. By adding an after event to Order=Yes I kept track of sales made.
Now this gets messy and my question is what is the best idea to correct this?
The set-up is:
tblExternalList has basic field such as address, name etc. plus ID as PK
tblExternalList_enhanced has above field plus add. all call info
tbl External List and tbl ExternalList_enhanced are in a 1-1 relationship on field ID
Form is bound to a qry which has field from ExternalList and ExternalList_enhanced
What is the best way to get the functionality that an agent can add a new record each time they need to??? I wanted to ask this before fiddling around with autonumber etc.
Many thanks for anyone who can give me some good advice
Regards
