Restricting the amount of entries

[IanH]

hi,

I am currently developing an access database for a video library. I
have a Videos Rented Table that includes the Rental ID, Video ID and
the Copy Number. I want to restrict the amount of videos taken out by
each member to 3. How would i go about doing this.

Thanks
Ian

[Bob Quintal]

"IanH" <hi********@yahoo.co.uk> wrote in
news:11*********************@u72g2000cwu.googlegro ups.com:

hi,

I am currently developing an access database for a video
library. I have a Videos Rented Table that includes the
Rental ID, Video ID and the Copy Number. I want to restrict
the amount of videos taken out by each member to 3. How would
i go about doing this.

Thanks
Ian

Videos Rented table should include the Member ID and Date
Returned. Then you use the Dcount() function to validate that
the number of active rentals is <= to your max_rentals (3).
You can then code the form to prevent further entries.

Dcount("[Member ID]","[Videos Rented]", "[Member ID] = " _
& Forms!CheckOut!txtmemberID & " AND [Date Returned] is null")
--
Bob Quintal

PA is y I've altered my email address.

[IanH]

Hi

I have a Rentals Table that includes the Rental Id, Member Id, Date
out, Date Return, Cost and this table is linked to the VideosRented
Table (Rental id, Video id, copy number).

I don't want to include the MemberID and the Date Returned in the
VideosRented table as i would have redundant data. Can i still use the
above code.

Ian

[Bob Quintal]

"IanH" <hi********@yahoo.co.uk> wrote in
news:11**********************@j33g2000cwa.googlegr oups.com:

Hi

I have a Rentals Table that includes the Rental Id, Member Id,
Date out, Date Return, Cost and this table is linked to the
VideosRented Table (Rental id, Video id, copy number).

I don't want to include the MemberID and the Date Returned in
the VideosRented table as i would have redundant data. Can i
still use the above code.

Ian

You would need to make a query joining the two tables.

But I foresee some issues with your structure. Say I'm your
client. I rent three movies on monday. I return one on tuesday,
one on wednesday, one on thursday. How will you track my status
on wednesday?
--
Bob Quintal

PA is y I've altered my email address.