Is It Possible?

[Mian Umar]

Hello All.

I Explain in a very simple way hope u understand my problem. (One thing I know all about Relationships And how much Fields Are using by me). Thats why I Tell my Problem in a very simple way So Here it is

Let

I have A Movie Name Field And Three Records In It. ( Want to send on RENT)

A Issued on 1 DEC 2006

B Issued on 2 DEC 2006

C Issued on 3 DEC 2006

OK NOW

So The Problems ARE:

1. A is already on rent, So How i control that When End User Again Write A in Field its Show Its already on Rent.(If I perform Unique Value Then Comes Another Porblem That is (See 2. Problem..)

2. The Anohter Problem is When A is Return Then The Previous Record is Saved And Movie Name A is already Stored in it. So When Agian Its Going on rent Then If Unique Apply then its not contaion this value agian.

SO How i can Handle These Problems

Please Help me in these.

I am very thankfull to all of u.

Mian Umar