J
JLDLS
I have created a project tracking database in Access 2007. I have seperate
tables/forms for clients and projects. The tables are linked by client name
(originates in the client table and is selected in the project table). On my
clients form I have added a tab that I would like to use to display all the
projects for that client. I am assuming that I will need to use a query in
the form to accomplish this. How do I get the query to instead of asking for
a name, to select the name of the curent open client in the form? Thanks.
tables/forms for clients and projects. The tables are linked by client name
(originates in the client table and is selected in the project table). On my
clients form I have added a tab that I would like to use to display all the
projects for that client. I am assuming that I will need to use a query in
the form to accomplish this. How do I get the query to instead of asking for
a name, to select the name of the curent open client in the form? Thanks.