Row source combo box limiting by previous field?

[Jaazaniah]

Is this possible? Here's the scenario, the tracking system is meant to
track time spent on client/project/activity with each of those being
heirarchal. That is to say I have 4 tables that are linked similar to
this

Clients:
ClientID
Texts

Projects:
ProjectID
Client>Clients.ClientID
Texts

Activities:
ActivityID
Project>Project.ProjectID
Texts

Hours:
Date/StartTime/EndTime
Client>Clients.ClientID
Project>Projects.ProjectID
Activity>Activities.ActivityID

My question is, is it possible to use the Combo Box lookup option to
filter the Row Source for Project/Activity based on the value in the
previous field? or is this more of a form relations issue?

Technically I could ONLY store the ActivityID, and use the forms as
user aid to filter out combo boxes, but wondered if there was a way to
do this on the table level?

Thanks.

 

[KARL DEWEY]

I think I understand what you want.
Use the AfterUpdate event to set the default for the Combo Box lookup.

 

[KARL DEWEY]

Silly me, I was assuming that the data entry was using a form/subform.