J
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.
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.