I haven't even attempted to add the 6 tabs to the mix yet. I was planning on getting my head around how to design this db, get it working with the first sheet, and then adding them later. Thanks again.

Just to explain my situation a little more, this is what the excel forms looks like:



There are actually 45 lines per screen, and 6 different tabs. Most forms are completely filled in when we receive them. The older database we are using has every single cell defined as a variable, and my goal is to create a normalized version of that database in Access that still gives the user a nice easy interface to enter all this...

Hi ADezii,
Thank you for the quick response and for the example. My problem is that I don't want the user to have to select column by column or row by row, we receive the data in an excel spreadsheet that is 45X6 and almost every cell usually has an entry. I'd like to design a form that approximates the spreadsheet for data entry. I have a feeling I might need a sub form for rows, and a sub sub for columns, but I haven't been able to find...

Hi Everyone,
I am working on a project that seems to need two many to many relationships. I'm having the hardest time figuring out the best way to create a form that will work well for entering data.

The data for this project is received in Excel files that have many rows (about 45) and several columns (about 6). I have posted an image of my relationships screen below.



Does it looks like I'm on...