Trouble setting up table.

[zgray]

Im having trouble trying to figure out the best way to set up a table that looks at 3 things instead of 2. For example I have a table that has all my branches and the columns are all the programs. Then I use a dlookup using the branch and program to find the number I need. Now I have a third one to look at. I have to find the branch, the program and then each program has 11 or so rates. Using them 3 variables I can search for the right number. Does that make sense? I have an excel sheet with all the data. Every idea I have just doesn't seem feasible.

 

[jdraw]

Database is different than spreadsheet. You may want to work through the attached tutorial to get a look at designing a database. Good luck.

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

 

[Weresmytriple]

could u upload the spreadsheet you are trying to create the database from, or at least a screenshot. also could u explain what the database has to search for as it is unclear in the previous post

 

[zgray]

Thanks for the help but I figured out a better way over the weekend. Instead of one table I split it into 7. With the one variable as the table itself and the other 2 in the table and it's been working fine.

 

[Weresmytriple]

ok glad u figured away around it