Check Field

[Mian Umar]

Hello All.

I created tables 4 movie rental system.

Now Once a movie is on rent then how i check it is on rent so its not sent again on rent.

Unique value is solution of this But when movie back then how i check its back And then Now this can be sent on rent.

I have have Issue Date And Return Date Fields

Is it possible i Check this with Return Date With comparison of System Current Date.

Plz Tell me

If Script or Function available then Tell me.

Thanks

Mian Umar