Need Recommendation

[Tom]

I have a one-to-many relationship between "Organizations" and "Projects".

The fields that further describe the organizations are stored on a main
form. Then I have a subform (datasheet view) that holds information about
its subordinate projects.

For data entry, I use a combo box on the subform from which the user can
select the projects that are subordinate to an organization. The projects'
information (for the combo) is pulled from a relatively static table e.g.
called "tblSourceData". The actual records are then stored in a table
called e.g. "tblStorageData".

When entering a new record, the subordinate projects for a specific
organization are all listed in the "datasheet" view.

However, I simply don't want to list the entire subset of projects for the
selected organization. However, I do want the entire subset of projects
listed in the combo box. I don't want "hard code them" into the combo's
row source though.

Does anyone have a recommendation to dynamically pull the row source from
the tblSourceData but not show all of the project values in the datasheet
view. I only want to see those records that actually have been selected
from the combo box and are stored in the tblStorageData. Does that make
sense?