Best way to pull up info

[Guest]

I have a 2 departments here, each use their own tables to store project
information. This will be used by Infopath and I need to figure out what
would the best way to accomplish the following:

When the user selects their name, I want it to show only the project numbers
that are in their department. I have a staff listing table with everyone in
it for both departments. Will I have to assign the group ID in there and the
project tables and match them up via that way?

Just need some advice,
Jeff

 

[Guest]

I suggest writing a query (based on the staff listing table) that will
display a person's name and department identifier (is that the same as the
Group ID?). Use another query to link this query to the person's name and
the project tables to see only the desired projects.