Search results

That is exactly what my question is. What exactly is normalized table structure and how does it apply to my situation? I think I can figure the rest of it out on my own (if not I'll be back). I have read threads on normalized table structure, but have found them all confusing, and didn't quite...

I occassionally make small, uncomplicated databases for my dad, and the program in very new to me, so I usually look online for help on how to do things. This time my question is on how to design a database. The purpose of this database is to act as a questionare given to residents in a medical...

All I really need to do is make it so that I can choose multiple venues for the same competency, a one-to-many relationship is one possible way to do this, but a long one, because i would have to restructure everything. My idea was to simply make it so that the combo box was not bound to the...

That is another way to accomplish what I've already done, and probably a better way. What I need to know is how to make it so that i can select multiple venues for the same competency. Will this design somehow make it easier to accomplish this?

Sorry for my lack of clarity. I have 30 tables which each have two columns: competency, and venue. There are 30 tables because each competency falls under a certain field, such as my earlier examples of medical ethics and professionalism, which are simply the name of the tables. I use forms with...

I've been sick so I didn't feel up to working on this, but I'm back now. I see what you are saying David, that was quite clear and I understand it. Unfortunately, I already have my tables set up in a different (and much simpler) fassion. All I did was have the table set up with two columns...

I kindof understand what you are saying, but I'm quite new to access, how exactly would i go about creating a continuous subform? I havent created any subforms yet, and I find that a few pointers from someone who knows what they are talking about can save you a lot of time. Thanks again for your...

Your guess is correct. I didnt know that having my list box bound to a field in a table would screw things up. Is there some way i can get around this and make it work?

I have tried using a list box some, but i cant get it to work. My form is in table form (looks like a table), does this effect the list box somehow? I have tried using the multiselect option on both simple and extended, but it just wont work. I am using a value list with about 10 options in it...

This is very similar to another quite recent post, but i didnt quite understand the responses to it, so bear with me. I have a database in which a forms are being used to input data into tables through combo boxes. I then use a union query to put all the tables together so i can extract common...

I took your advice, and it should work just fine. I guess there is some sort of a limit. Thanks John

I found two other postings on this problem, but neither of them had a posted solution. I am trying to create a union query that joins 21 tables together. Parts of it were working fine, but the completed query doesnt work. It just gives me the error "Not a valid alias name" when i try to view it...

Thanks a lot, im tried using a union query and it works perfectly

Each table has 2 columns, one is a section of medical practice, and the other is the venue for learning. I made a different table for each section of medical practice, each of which has about 6 areas. I made forms using combo boxes to input the data into all of them. The problem i have now is...

I have appended several tables to the bottom of another table, but i need to have the new table updated from the old tables whenever they are changed. Im sure it is something rather simple, but i am new to access. Thanks in advance for your help

I know i need to use an append query, but i dont know how to make an append query that will do that Help please

This is probably something very simple, but I just started using access a few days ago. I want to add one table to the bottom of another table. I'm pretty sure that i have to do this with an append query, but i have messed around with it for a few hours with no success. Thanks in advance for...