Recent content by newbie2db66

Thanks so much guys. You've solved my problem and given me extra ideas on top. Fab!

yes thats what I was told come to think of it! So how would the new table link in with the others? and would it be a many to many relationship? Thanks for your help:)

Hi I'm very new to Access databases and I'm trying to set up a system for a DVD rental shop. At the moment I have my tables set up as in the attached screenshot, but I've been told that this is not normalised and won't work properly. Apparently I need to add another table. I'm also not sure...