combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of training in my combox box. when i make my selection where will the data be held? It only stays on the form . But each record will have numerous training and I need to keep them all but I don't want to keep typing in the name and address. Im i suppose to make another table for it and how do i get it go go into i
Thanks
 
I have a list of training in my combox box. when i make my selection where will the data be held? It only stays on the form . But each record will have numerous training and I need to keep them all but I don't want to keep typing in the name and address. Im i suppose to make another table for it and how do i get it go go into it
Thanks
Click to expand...

Jenny,

You're starting at the wrong end, it appears! Don't build your combo
boxes, and then your forms, and then your tables - that's like
building your windows, and then your walls, and then figuring out
where to put the foundation!

The Tables in your database are the basis of your application. You
should use the principles of "Normalization" to design your tables
FIRST. Essentially, you need to identify the "entities" - real-life
people, things, or events - of importance; each type of Entity gets
its own table. For example, you should have a table of Students; a
table of Classes, or Training Events, or whatever you call it; and an
Enrollment table linking the two. When you enter a student's name and
address, you should enter it *ONLY ONCE*, and only in the student
table.
 
Joh
so how do i connect the combo bo

----- John Vinson wrote: ----

On Sun, 8 Feb 2004 07:21:07 -0800, "jenny
I have a list of training in my combox box. when i make my selection where will the data be held? It only stays on the form . But each record will have numerous training and I need to keep them all but I don't want to keep typing in the name and address. Im i suppose to make another table for it and how do i get it go go into i
Thank
Click to expand...

Jenny,

You're starting at the wrong end, it appears! Don't build your comb
boxes, and then your forms, and then your tables - that's lik
building your windows, and then your walls, and then figuring ou
where to put the foundation

The Tables in your database are the basis of your application. Yo
should use the principles of "Normalization" to design your table
FIRST. Essentially, you need to identify the "entities" - real-lif
people, things, or events - of importance; each type of Entity get
its own table. For example, you should have a table of Students;
table of Classes, or Training Events, or whatever you call it; and a
Enrollment table linking the two. When you enter a student's name an
address, you should enter it *ONLY ONCE*, and only in the studen
table


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=publi
 
John
Here are the tables i have
Staff
Training
Department
Title
Each of these tables has a list to choose from. I want to make a form and have all the tables on it in combo boxes. Can that be done? Do all these tables have to have a relationship?

----- John Vinson wrote: -----

I have a list of training in my combox box. when i make my selection where will the data be held? It only stays on the form . But each record will have numerous training and I need to keep them all but I don't want to keep typing in the name and address. Im i suppose to make another table for it and how do i get it go go into it
Thanks
Click to expand...

Jenny,

You're starting at the wrong end, it appears! Don't build your combo
boxes, and then your forms, and then your tables - that's like
building your windows, and then your walls, and then figuring out
where to put the foundation!

The Tables in your database are the basis of your application. You
should use the principles of "Normalization" to design your tables
FIRST. Essentially, you need to identify the "entities" - real-life
people, things, or events - of importance; each type of Entity gets
its own table. For example, you should have a table of Students; a
table of Classes, or Training Events, or whatever you call it; and an
Enrollment table linking the two. When you enter a student's name and
address, you should enter it *ONLY ONCE*, and only in the student
table.
 
John
Here are the tables i have
Staff
Training
Department
Title
Each of these tables has a list to choose from. I want to make a form and have all the tables on it in combo boxes. Can that be done? Do all these tables have to have a relationship?
Click to expand...

Jenny, I'm sorry. Your questions indicate that you're plunging in,
probably over your head. You're still asking about forms and combo
boxes - and you don't even have any indication that you know what a
relationship IS. If you proceed at this level, you will get into a
real mess!

Again - *the tables are the foundation of your application*. If you
don't have properly structured and related tables YOU DON'T HAVE A
DATABASE.

I would STRONGLY suggest that you stop, and get a good book about
Access, one that introduces the ideas of database design. There are
many, one I like is my colleague John Viescas' _Running Micrsoft
Access_; there are also some good introductory websites. You list some
table names, but I have no idea what they contain or what you want to
do with them, but "a form and have all the tables on it" will almost
certainly NOT be a desirable end product.
 
John can i send you my database and you fix i

----- John Vinson wrote: ----

On Sun, 8 Feb 2004 16:56:06 -0800, "Jenny
Joh
Here are the tables i hav
Staff
Trainin
Departmen
Titl
Each of these tables has a list to choose from. I want to make a form and have all the tables on it in combo boxes. Can that be done? Do all these tables have to have a relationship
Click to expand...

Jenny, I'm sorry. Your questions indicate that you're plunging in
probably over your head. You're still asking about forms and comb
boxes - and you don't even have any indication that you know what
relationship IS. If you proceed at this level, you will get into
real mess

Again - *the tables are the foundation of your application*. If yo
don't have properly structured and related tables YOU DON'T HAVE
DATABASE

I would STRONGLY suggest that you stop, and get a good book abou
Access, one that introduces the ideas of database design. There ar
many, one I like is my colleague John Viescas' _Running Micrsof
Access_; there are also some good introductory websites. You list som
table names, but I have no idea what they contain or what you want t
do with them, but "a form and have all the tables on it" will almos
certainly NOT be a desirable end product


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=publi
 
John can i send you my database and you fix it
Click to expand...

I expect that I could. I'm a self-employed freelance consultant, and
I've fixed many databases. May I send you a resume with my schedule of
fees? If so please email me at

jvinson <at> wysardofinfo <dot> com
 
Back
Top