D
Dylan
Hi,
I have a small simple database that keeps track of leads that are allocated
to three staff. The db contains two tables:
Table 1 - "tbl_lead":
leadID
accountNo
companyName
date
repID
Table 2 - "tbl_rep":
repID (linked to repID in tbl_lead)
repName
I have a form that the user enters account name, company name, date and
selects rep name via a combo box. As a process we need to allocate the leads
to three reps sequentially (to make sure the workload is even). The user
will be frequently interrupted and may not remember which rep was allocated
the last lead. I would like a field in the form that displays who received
the last lead and what the company name was (without activating a command
button or the like).
Any ideas?
Dylan
I have a small simple database that keeps track of leads that are allocated
to three staff. The db contains two tables:
Table 1 - "tbl_lead":
leadID
accountNo
companyName
date
repID
Table 2 - "tbl_rep":
repID (linked to repID in tbl_lead)
repName
I have a form that the user enters account name, company name, date and
selects rep name via a combo box. As a process we need to allocate the leads
to three reps sequentially (to make sure the workload is even). The user
will be frequently interrupted and may not remember which rep was allocated
the last lead. I would like a field in the form that displays who received
the last lead and what the company name was (without activating a command
button or the like).
Any ideas?
Dylan