By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Limit number of records able to be entered

P: n/a
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
Jan 2 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <OM@youknowwhere.comwrote 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


Jan 3 '07 #2

P: n/a
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" <OM@youknowwhere.comwrote 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



Jan 4 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.