any ideas?

[bbcwjun]

I have 2 forms that collect the some of the same data: 1 form- (Ph. #, Video #, Rental Date). 2nd form- (Video#, RETURN Date). Both forms use the same query/table but the 2nd form, when I type in the Video #, if the person has seen the video# already, it says "unsuccessful due to duplicate ..etc.." cuz I made it a primary key. I can take it off as a primary key but the thing is how can I and where can I make it so that once you enter the video # in the 2nd form, it automatically searches if the SAME person saw the same Video# before and displays a message like "Seen it" somewhere on the form?? I'm a newbie so any help is appreciated!! THANNNNNKKSS!

 

[BNPMike]

Your first problem is you have the wrong key. The key is nothing to do with forms.It is what is the key. In your case it must be Video/Person/Date since there is nothing to stop a person taking out a film twice. This assumes they only take out one of the same film on the same night - wouldn't work for the Video shop down the road if you have them as a customer.

The second form has the return date - and you want to show whether that person also took this film out before? I can only think you would want to do that on the first form so you could say "You realise you have seen this already,sir".

Can you clarify? mike.stephens@bnpparibas.com