help with combo / text boxes

[qwas2123]

Hi, Im new to the forum and i would appriciate any help anyone has to offer.
well ok, i have a personnel base and what i would like to do would be to be able to tie

The information that is input into a combo box that would automatically fill the 6 or 7 relational text boxes underneath that with the information that correpsonds to the rest fo the fields.

Then as a quick question i would like to know, because as of now i have yet to create any relationships between the tables, that in order to do this i have to create any relationships between the different fields

I hate to bother anyone but if you can either point me in the direction of another places where this is already stated and/or give me a quick solution its greatly appriciated.

Thank You

[comteck]

You probably do require a relationship between various tables. However, it is hard to tell with the information you've provided.

Could you please include a better explanation of what you are trying to achieve, and include any tables with fields and PKs.

comteck

[qwas2123]

No problem, sorry, well see basically im trying to build a training base log, which shows all the training courses and what not, records of all of the bookings for the classes and then theres a list of all the personnel in the program.

what im tyring to do is basically, under the personnel form, ill type in an ID number of one of the piolts and then from that information in about 7 total text boxes under the ID number, will come up the rest of his information, like an auto fill or what not.

But im trying to see if mabye ill have to create some sort of relationship between 2 tables that i have, and itll work that way, and or get and expression of some sort and go figure it out from there.

really im sorry to bother but this is killing me. and thank you for your help

[skendrot]

I think you need to provide your table structure and field names and a more clear description of what you are trying to do to get any real assistance from the experts here(I am not one...). It seems to me you should have at least three tables...one for course ID, one for sessions/booking, and one for personnel (not clear if that is attendees or instructors). Try looking at the northwinds sample database to see how nested forms can display records based on a selection in the main form.