Thank you for the response! You've taken a lot of time to detail what is wrong and after reading more onormailzation (I found the Wikipedia version very hard to follow, but found a better one on About.com) I believe I understand.
However, your response has raised a question with regard to the...
I don't know if I'm completely dense or if it is the flu that is causing my cognitive abilities to go right out the window. In my mind, this is the simplest thing, but maybe I'm going about it all wrong.:confused:
I am creating a worksheet form, that pulls data from multiple lookup tables...
More Details on my Database (as it is now)
Ok, here is more structure to the Database as it is currently:
tblIOLookup
Fields:
IO (number, Primary Key)
IO_Desc (txt)
IO_Cat (txt)
tblGLLookup
Fields:
GLID (number, Primary Key)
GLDesc (txt)
GLType (txt)
Budget (number, set statically one...
Again, thank you for your help - I was hoping that your good karma would help in getting your questions answered (I looked at this myself but short of removing the Undo item from the Access Toolbar, I didn't have a solution short of this possibly being at the Windows Registry level).
I have...
:o Thank you for the response!!
Now, it has been more than four years since I actually "programmed" an Access DB and so I would just like confirmation on where to put the DSum entry listed above. I believe it goes in the Form but not sure where.
As for IO and GL, it is only the GL Accounts...
My brain has pretty much gone to mush after three days of banging my head, so I am reaching out for help! I hope this does not get too confusing during my explaination.
I am using Access 2003 (and must use Access 2003 due to standardization) to set up a financial database to track...