Limit number of records able to be entered

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OM - 02 Jan 2007 11:42 GMT

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

Reply to this Message

Kc-Mass - 03 Jan 2007 10:54 GMT

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

>I have two tables, one with categories in it, and only 3 records - Wages,
>Salary, Contract.
[quoted text clipped - 11 lines]
>
> Rob

Reply to this Message

OM - 04 Jan 2007 10:24 GMT

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

Regards,

Rob

> Put all the fields in a single form. Form SubForm is intended to produce
> multiple records
[quoted text clipped - 24 lines]
>>
>> Rob

Reply to this Message