any ideas anyone?

[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!

 

[Peter Whitfield]

How about,

In your main table, have an additional field that defaults to "Seen It". Then insert a subform in the 2nd form which links on the Person and Title and displays only the new "Seen It" field. If they have had it before it will show, if not its blank!!