Limit number of duplicate records per field

[lanjoudun via AccessMonster.com]

In my database, a client can make an invoice which allows them to pick dates
to hold a session with a personal trainer. So, I want to limit the number of
Sessions that can be entered under one invoice.
Example: Client wants 8 sessions in 28 day (month) period (this is all
decided by the payment details in the invoice). I want to force the data
entry user to create all 8 sessions within the the month without going over
or under the limit. I would love to learn how to automate this approach so
upon invoice creation, sessions are made automatically according to client's
schedule.

 

[Tom van Stiphout]

On Mon, 06 Jul 2009 03:12:29 GMT, "lanjoudun via AccessMonster.com"

You don't provide enough information.
First you speak about limiting (I am assuming: the user) to the dates
in a 28-day period.
Then you speak about automatically creating 8 sessions within this
period. On random date/times? On available ones? On first available
ones?
Can you elaborate? Note that we know nothing about your business or db
design.

-Tom.
Microsoft Access MVP