This is making more sense now--thank you! Follow up question for you. If I wanted to track the name of the person who is working on or reviewing the document if DocumentStatus = "In Work" or "In Review," would the structure be as follows?
tblStatusName
StatusNamePKey~
StatusName (I don't...
I can't seem to wrap my mind around the concept.
I'm working on a database to track technical documents that is supposed to be as flexible as possible.
The tables I've created are:
tblDocumentTitle
DocumentTitle
DocumentTitleID
tblDocumentNumber
DocumentNumber
DocumentNumberID...
Hmm, this makes sense but I can't make it work--meaning the control is visible when I start and doesn't go anywhere regardless of what I choose from the combo box. Might I be missing something in my form setup?
I haven't used Access in a looooong time and building a document tracking database for work. I am setting up my data entry form and would like to have a text box appear depending on the selection from a combo box. So, if the user selects "In Review" a text box will appear for entry of the...