Search results

I am looking at the samples provided in that thread now. If I go with your suggestion of tblStaff and tblAddresses I will still need an answer to my original question. How can I allow a user to enter a new staff member and address in a form and not have to deal with knowing or finding the...

I read in several of the books and forums that if you have data that is repeated then you should put it in its own table and form a relationship so the data was only in the database once, saving space in the database and ensuring data integrity. The way it is set up each staff member can have a...

I am new to Access, and have spent the last few weeks reading everything I could get my hands on about creating databases. I am working on a new database for my office and I need some help please. I am trying to create normalized tables, so I have broken down my tables into the smallest...