B
Bastard_Toadflax
Hello all!
I have a question about a database form I'm trying to sort out. I've
got it all set up nicely, but what I'm trying to do is make it so that
it draws the data from a query - and this is where it all goes
haywire. I'll give some information about what it is I'm trying to do.
It's a database for orders, and as per usual I have several tables
with various data in the tables. I have a table for employees - and
then within this table one of the data fields is a series of check
boxes around the specific duties the employee can do (Processing
officer, requesting officer or authorising officer). What I want my
form to do is have a drop down menu for each of processing officer,
requesting officer and authorising officer, where you can select which
one is doing the respective work. So I've made a query to pull the
relevant officers out of the database, but I can't seem to get that
information onto my form properly. I've tried going in to the Record
Source properties and including the fields from my query in the form,
but it doesn't like it for some reason, as well as the fact I can't
seem to fit the query into the relationship part of the screen (i.e.,
the relations between the tables are fine, but the query doesn't fit
anywhere, even when I try to join it). On the form it comes up with a
heap of records that aren't there (so it's cross-referencing
incorrectly) when I try to add my query to the relationship screen, or
when I remove my query from the relationship screen it has a #Name?
error in those fields...
Any ideas on this one would be very much appreciated.
Thanks.
I have a question about a database form I'm trying to sort out. I've
got it all set up nicely, but what I'm trying to do is make it so that
it draws the data from a query - and this is where it all goes
haywire. I'll give some information about what it is I'm trying to do.
It's a database for orders, and as per usual I have several tables
with various data in the tables. I have a table for employees - and
then within this table one of the data fields is a series of check
boxes around the specific duties the employee can do (Processing
officer, requesting officer or authorising officer). What I want my
form to do is have a drop down menu for each of processing officer,
requesting officer and authorising officer, where you can select which
one is doing the respective work. So I've made a query to pull the
relevant officers out of the database, but I can't seem to get that
information onto my form properly. I've tried going in to the Record
Source properties and including the fields from my query in the form,
but it doesn't like it for some reason, as well as the fact I can't
seem to fit the query into the relationship part of the screen (i.e.,
the relations between the tables are fine, but the query doesn't fit
anywhere, even when I try to join it). On the form it comes up with a
heap of records that aren't there (so it's cross-referencing
incorrectly) when I try to add my query to the relationship screen, or
when I remove my query from the relationship screen it has a #Name?
error in those fields...
Any ideas on this one would be very much appreciated.
Thanks.