Hello All again,
Ten years ago I created a somewhat half-decent custom database for my place of employment, and after some 9 or so years of not working with Access, I fooled myself into thinking that I could very simply create a database again. I had NO IDEA how big a fool I was!
This simple, easy database is a BIG nightmare.
I'm volunteering Saturdays at a local mechanic's shop just to get out of the house and to learn some new skills, and while I was sorting and organizing oil filters, I thought that it might be handy to have a database that would keep track of it all, and that it might give me a chance to play with Access again and re-learn my lost Access almost-skills.
It's surely child's play for you, which is why I'm asking if someone might have a few mins. to just look at it quickly and suggest what I'm doing right, or wrong, in the basic design and in the way I'm going about implementing the database functionality.
I have spent many days trying to get the darned thing to work... I DO NOT AT ALL care about "prettying" it up at this point in time, I know it looks like sh*te, but that's irrelevant, I'll work on that later, I just need figure out how to best make the darned thing work at this point in time. Later I will make a switchboard which will tie together all the forms.
The most important part is that I want to be able to go to a form, select a Auto Manufacturer, then select an Auto Model, from there select a Filter Manufacturer, and then select the corresponding Filter Number. By doing this, I enter into a table the filter numbers that correspond to certain auto models. Then ideally, one could go to the View form of said data, search a certain auto model, and get a list of all filter numbers that will be acceptable for use with that vehicle model. Why is this sooooooo difficult to accomplish?????
Am I imagining things, or have I read on many forums that one should not store the actual text in certain tables, but rather the corresponding table's ID number instead? I'm asking 'cause one of the tables, to store the information I've just outlined in the paragraph just above, stores the Auto Manufacturer ID, the Auto Model ID, the Filter Manufacturer ID, and the Filter Number, so the table is comprised of a auto-number ID, and the four above-mentioned IDs. Now when I want to see the text equivalents of the above IDs, I can't seem to figure out how to get that done.
Any suggestions very appreciated.
Ten years ago I created a somewhat half-decent custom database for my place of employment, and after some 9 or so years of not working with Access, I fooled myself into thinking that I could very simply create a database again. I had NO IDEA how big a fool I was!
This simple, easy database is a BIG nightmare.
I'm volunteering Saturdays at a local mechanic's shop just to get out of the house and to learn some new skills, and while I was sorting and organizing oil filters, I thought that it might be handy to have a database that would keep track of it all, and that it might give me a chance to play with Access again and re-learn my lost Access almost-skills.
It's surely child's play for you, which is why I'm asking if someone might have a few mins. to just look at it quickly and suggest what I'm doing right, or wrong, in the basic design and in the way I'm going about implementing the database functionality.
I have spent many days trying to get the darned thing to work... I DO NOT AT ALL care about "prettying" it up at this point in time, I know it looks like sh*te, but that's irrelevant, I'll work on that later, I just need figure out how to best make the darned thing work at this point in time. Later I will make a switchboard which will tie together all the forms.
The most important part is that I want to be able to go to a form, select a Auto Manufacturer, then select an Auto Model, from there select a Filter Manufacturer, and then select the corresponding Filter Number. By doing this, I enter into a table the filter numbers that correspond to certain auto models. Then ideally, one could go to the View form of said data, search a certain auto model, and get a list of all filter numbers that will be acceptable for use with that vehicle model. Why is this sooooooo difficult to accomplish?????
Am I imagining things, or have I read on many forums that one should not store the actual text in certain tables, but rather the corresponding table's ID number instead? I'm asking 'cause one of the tables, to store the information I've just outlined in the paragraph just above, stores the Auto Manufacturer ID, the Auto Model ID, the Filter Manufacturer ID, and the Filter Number, so the table is comprised of a auto-number ID, and the four above-mentioned IDs. Now when I want to see the text equivalents of the above IDs, I can't seem to figure out how to get that done.
Any suggestions very appreciated.