not sure on title...but would appreciate some help

[qwertybob]

hello, this is my first post here, and im in need of help

i have some tables set up as shown in the included image

i need a way to display data from tblCopy/tblMovie on a form, but excluding those records that have a related record in tblRental

thankyou in advance for any assistance offered

(sorry if this is in the wrong place as i wasnt sure where to put it)

 

[Crilen007]

You have to create a form based off the rental table.

Then insert a subform based off the copy table, then a subform in that subform based off the movie table.

I hope that makes sense... If you zip and post your DB I can do a fast example using your database.