D
Daniel
Hey
I have a form that has numerous fields on it, including an
Employeeid, Site, Job.
These three together make up the primary key of the
underlying table.
What i want to do is filter the job combo box based on
what is selected in site. I have tested it and can do this
if i just use an autonumber as the primary key and after i
select a site i refresh the form.
But when i use the three as the key it doesn't work cause
as soon as i change site it refreshs the form as looks for
the key which might not exist because of the new site
selected combined with the old job selection.
Hope this makes sense.
cheers Daniel
I have a form that has numerous fields on it, including an
Employeeid, Site, Job.
These three together make up the primary key of the
underlying table.
What i want to do is filter the job combo box based on
what is selected in site. I have tested it and can do this
if i just use an autonumber as the primary key and after i
select a site i refresh the form.
But when i use the three as the key it doesn't work cause
as soon as i change site it refreshs the form as looks for
the key which might not exist because of the new site
selected combined with the old job selection.
Hope this makes sense.
cheers Daniel