Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

no duplicate records in child records

Status
Not open for further replies.

video32a

IS-IT--Management
Apr 24, 2000
28
US
First I am doing this with a subform.<br>I have parent tbl1report linked to childtbl2report and childtbl2notes. I am trying not to have duplicate records in childtbl2notes for each parent. Any one have code that works with its own message box to stop duplicate records in this area only. Thank you in advance for any ones help!
 
couldn't you base childtbl2notes on a query that has Duplicated Values set to No. Then load the query with a variable set to whatever the mainform requests.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top