Hi there, thanks.
I've actually managed to come up with a solution using VBA, which when a pop-up form loads it creates an SQL string based on values it pulls from the currently open form.
The key bit I was missing was the "In (x,y,z)" to use the query criteria as i'd never used this before.
Mark Heptinstal
Last Activity: Apr 28 '11, 02:40 PM
Joined: Apr 4 '11
Location:
-
Combobox showing Staff with relevant qualifications
Hi
I am having some trouble coming up with a solution so that a combobox only lists staff members at a particularly who have the relevant qualifications associated with a service.
Perhaps I have the table design wrong (please see the link at the bottom of my question for the relationship image) to do this kind of thing:
Here's what I am looking to achieve:
A pharmacy provides a service which may...
No activity results to display
Leave a comment: