If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Confused over new db
I am in the process of creating a db for a project, I have been given several
forms (paper forms that folks will be using to ask patients questions) that need to be created which is whats confusing me. I know how to create access forms, but I'm confused on how I should build my tables. I know I will have a patient name, #, address, etc. - this is the easy part. Then looking at the forms (about 5 forms) these all ask different questions, here's an example: Discharge Disposition (check one of the options below) Home Rehab Skilled Nursing Ok this one I get, just create a combo box and have the choices in a drop down but, then there's: Medical Conditions (check all that apply - there's about 20 diff choices) • Arthritis • Depression • Diabetes • Heart • etc. • Other: ______________________ How can I set up a form that will let me choose more than one option? And how do I set it up that users can choose Diabetes, Heart, and Other then type in something? Do I have to create a table with every question on it to be able to use an access form??? All of my forms are ones with questions for our patients similar to the examples provided. I have not worked on access in a long time and I'm a little unsure of how to set these up. I know I've seen it done before but I'm lost right now. Also I'm using MS Access 2002 (if it matters) |
Thread Tools | |
Display Modes | |
|
|