Hi,<br>
<br>
I have a group of typists who type for different hospitals. Some typists work for more than one hospital.<br>
When our payroll clerk enters the number of reports typed by each typist I want to be able either limit the combo box of hospitals to that specific typist, or list all the hospitals.<br>
<br>
I have 3 main tables, Billing, Hospitals, & Typists.<br>
Here are the general layouts of each.<br>
<br>
Table Fields<br>
<br>
Typists TL Number (unique index), Name (Last,First)<br>
<br>
Hospitals Hospital (unique index), TLs (multiple typists)<br>
<br>
Billing Date, TL Number, Name, Hospital, Pages, Studies<br>
<br>
I'm thinking of putting a yes/no field for limit to list. That way we can set the typists that we want to be limited to the list. <br>
<br>
The part I'm stuck on is the logice behind the form for this. Any suggestions will be helpful.<br>
<br>
Thanks<br>
<br>
<p>Phil<br><a href=mailto:Thorn@full-moon.com>Thorn@full-moon.com</a><br><a href= > </a><br>Most of us go through life not knowing what we want, but feeling damned sure that this isn't it.<br>
<br>
I have a group of typists who type for different hospitals. Some typists work for more than one hospital.<br>
When our payroll clerk enters the number of reports typed by each typist I want to be able either limit the combo box of hospitals to that specific typist, or list all the hospitals.<br>
<br>
I have 3 main tables, Billing, Hospitals, & Typists.<br>
Here are the general layouts of each.<br>
<br>
Table Fields<br>
<br>
Typists TL Number (unique index), Name (Last,First)<br>
<br>
Hospitals Hospital (unique index), TLs (multiple typists)<br>
<br>
Billing Date, TL Number, Name, Hospital, Pages, Studies<br>
<br>
I'm thinking of putting a yes/no field for limit to list. That way we can set the typists that we want to be limited to the list. <br>
<br>
The part I'm stuck on is the logice behind the form for this. Any suggestions will be helpful.<br>
<br>
Thanks<br>
<br>
<p>Phil<br><a href=mailto:Thorn@full-moon.com>Thorn@full-moon.com</a><br><a href= > </a><br>Most of us go through life not knowing what we want, but feeling damned sure that this isn't it.<br>