Limit number of records able to be entered

[OM]

I have two tables, one with categories in it, and only 3 records - Wages,
Salary, Contract.

I have a second table that records hours and numbers of employees in each
category, per month. How do I limit the number of entries for each month to
the number of categories ? I only want 1 x Hrs and 1 x Numbers for each
category, for each month (the figures are entered each month).

I have a form (which has Month as the only field), and a subform for
category, Hrs, and numbers. I want the ability to enter data to stop when
each category is complete.

Thanks in advance,

Rob

[Kc-Mass]

Put all the fields in a single form. Form SubForm is intended to produce
multiple records
in the child table wich you do not want..

I assume table 1 is only a lookup table where the user can pick their
category and
the second table stores the Year, Month, Category, number_of_hrs and
Number_of_People for that Category, Month and Year. If you then make
Category, Month and Year into an index with no duplicates allowed, you're
set.

Kevin C
"OM" <[e-mail] in message
news:45**********************@news.optusnet.com.au ...

>I have two tables, one with categories in it, and only 3 records - Wages,
Salary, Contract.

I have a second table that records hours and numbers of employees in each
category, per month. How do I limit the number of entries for each month
to the number of categories ? I only want 1 x Hrs and 1 x Numbers for each
category, for each month (the figures are entered each month).

I have a form (which has Month as the only field), and a subform for
category, Hrs, and numbers. I want the ability to enter data to stop when
each category is complete.

Thanks in advance,

Rob

[OM]

Ahhh..... Thank you Kc-Mass.

Regards,

Rob

"Kc-Mass" <connearney_AT_comcast_PERIOD_netwrote in message
news:Y7******************************@comcast.com. ..

Put all the fields in a single form. Form SubForm is intended to produce
multiple records
in the child table wich you do not want..

I assume table 1 is only a lookup table where the user can pick their
category and
the second table stores the Year, Month, Category, number_of_hrs and
Number_of_People for that Category, Month and Year. If you then make
Category, Month and Year into an index with no duplicates allowed, you're
set.

Kevin C
"OM" <[e-mail] in message
news:45**********************@news.optusnet.com.au ...

>>I have two tables, one with categories in it, and only 3 records - Wages,
Salary, Contract.

I have a second table that records hours and numbers of employees in each
category, per month. How do I limit the number of entries for each month
to the number of categories ? I only want 1 x Hrs and 1 x Numbers for
each category, for each month (the figures are entered each month).

I have a form (which has Month as the only field), and a subform for
category, Hrs, and numbers. I want the ability to enter data to stop when
each category is complete.

Thanks in advance,

Rob