Hello – I am relatively new to MS Access and just joined this forum this evening. I apologize if this question has been asked and answered many times, but I couldn’t find it with my simple search.
I am creating a database for change proposals (CP’s) for my company’s engineering department. Each CP could impact multiple drawings (theoretically, this could be 1 to infinity) so I would like the user to be able to enter in all of the drawings that will be impact by the CP. I don’t think I can use simple text as in the future, users need to be able to easily conduct database searches to find drawing numbers that may be on previous CP’s (and if any of those CP’s are currently open, closed, deferred, etc.).
We have well over 100,000 drawing numbers and that number grows daily so I am thinking a lookup table won’t be feasible. Maybe some sort of multi value text field that is NOT a lookup? IS THIS POSSIBLE? IF SO, HOW?
If anyone has a better idea, I am open to suggestions.
Many Thanks in advance!!!!!