I am going to try and not ramble here but I want to give as much info as possible to help out any nice posters that can help me.
I have a database designed to record documents contained within a physical box. Because of the number of documents, each having it's own document number, I am limited by my boss to have the contents entered as a range of document numbers instead of entering them as there own individual records. Because of this I am limiting each physical box to only one type of document. So, I need a solution to do a user search for a document based on its type and within the range of documents contained in that box. For instance, "box 1" would contain a document type of "docType A" only and within the box the start range number field is "docNumberStart" of 100. Then we have another field of "docNumberEnd" of 199. A user needs to be able to use a form that would ask the document type and then a document number, say 150. I need to have the query to search the boxes based on the type first then see where that document number falls within the range entered for the box. This needs to query two tables already set up (cannot change much in them). Table 1: boxID (primary), boxNumber(no duplicates), docType(linked to Table 2), docNumberStart, docNumberEnd Table 2: docTypeID (primary), docType(no duplicates). Well, I hope that makes sense and someone can help. I do have some VB experience and have used it for some other coding in the database but I am a novice. Thanks for any assistance.
I have a database designed to record documents contained within a physical box. Because of the number of documents, each having it's own document number, I am limited by my boss to have the contents entered as a range of document numbers instead of entering them as there own individual records. Because of this I am limiting each physical box to only one type of document. So, I need a solution to do a user search for a document based on its type and within the range of documents contained in that box. For instance, "box 1" would contain a document type of "docType A" only and within the box the start range number field is "docNumberStart" of 100. Then we have another field of "docNumberEnd" of 199. A user needs to be able to use a form that would ask the document type and then a document number, say 150. I need to have the query to search the boxes based on the type first then see where that document number falls within the range entered for the box. This needs to query two tables already set up (cannot change much in them). Table 1: boxID (primary), boxNumber(no duplicates), docType(linked to Table 2), docNumberStart, docNumberEnd Table 2: docTypeID (primary), docType(no duplicates). Well, I hope that makes sense and someone can help. I do have some VB experience and have used it for some other coding in the database but I am a novice. Thanks for any assistance.
