Datasheet entry validation

[Fstrategic]

I have an issue involving two tables:

Table1: Project: ID Client ProjectName EffDate

Table2: WorkHours: ID WorkDate Client ProjectName WorkHrs Billable?

I have setup two TBL-Lookup fields in Table2, "Client" and "ProjectName"
"Client" is linked to a third table. ProjectName is linked to the Project table. (I need both lookup fields populated in the table)

IS there a way when entering data in the datasheet view to limit the list of projects to pick from to those belonging to the client entered in the new record field?

If not, could a validation data macro be written to prevent accidental mismatch (selecting a project that is not associated with the client)?



Appreciate any help
Thank you.

[orange]

Don't enter data in tables directly. Use Forms. restrict values via Comboboxes.


Don't use table level lookups.
http://www.mvps.org/access/lookupfields.htm

[Fstrategic]

I want to accomplish this using the Datasheet format. I don't have the skill level to develop complex forms. Any ideas how to get tis done through table design or writing validation expressions?