Hello Experts its me again. I have become very frustrated and dont know what I should do. First I like to tell you that I am not a expert on Access and most everything I have learned was because of you the experts. I want to thank you for that.
For those who dont know I have a database that was not made correctly now my boss is asking me to remake the database finally after over a year. The new database is basically a Inspection database that goes through over 200 hundred questions.
I have always done forms in a single format. Not a continous format. So alot of things that I was used to doing you have to do a different way. I have analyzed the survey example called "At Your Survey". This database is not helping me because it is setup to make a Questionaire database for you.
I have read articles for continuous forms but it really doesnt go in to detail about how to different things with a continuous form
If anybody knows of a better example please let me know.
The Issues I am running into are
1. How to make different information in a dropdown based on different questions on a form?
2. If you have over 200 question is it wise to make a second column to show up on the form to even it out?
3. Where do you put calculations to enter numbers and it calculates a Min and Max on the continuous form?
4. Should general information like Name and engine serial numbers be in a separate table?