Validation rules question

[cps6568]

I have a table, that has multiple occurrances of job title, job duties, and % time spent on each duty. For each title I want to make sure the total of the %'s do not exceed 100%. Can I do that within the table somehow, in the properties, if people enter data through the DataSheet view? If not, then through a form? And how? Thank you.

[RuralGuy]

It sounds like you a creating a normalization problem. I would consider each of those values in a different record of the same table in your design.

[cps6568]

It sounds like you a creating a normalization problem. I would consider each of those values in a different record of the same table in your design.

I'm not sure what a normalization problem is. Job titles are validated/limited by another table, also job duties. There is a 1:many relationship betwen them (1 job:many duties). The % time value is related to job duties. I want to make sure they don't exceed 100% for the rollup to each job title.

[RuralGuy]

Your description of the table violates the 1st Normal form, repeating groups. All entry to your tables should be through forms and *not* directly in tables. Access has no triggers in the tables so no real validation could take place there. What you want to achieve can be done with a MainForm and a SubForm.