473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

help with combo / text boxes

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
Aug 1 '06 #1
3 1418
comteck
179 100+
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
Aug 1 '06 #2
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
Aug 1 '06 #3
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.
Aug 3 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: meganrobertson22 | last post by:
Hi Everyone- I have a question about how to add and then use the "All" selection in a combo box. I am trying to figure out how to: (1) add "All" as a selection to a combo box and then (2)...
9
by: Edwinah63 | last post by:
Hi everyone, Please let there be someone out there who can help. I have two BOUND combo boxes on a continuous form, the second being dependent on the first. I have no problem getting the...
0
by: Tom | last post by:
I have some very strange issues with combo boxes on a tab control. Here's the scenario: I have a Windows Forms form that has a tab control on it, with two (2) tabs. Tab 2 happens to have a number...
4
Rabbit
by: Rabbit | last post by:
Cascading Combo/List Boxes This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one...
1
by: 1druid1 | last post by:
Hi all I have a TableAdaptor with the following Query.. SELECT Start, Finish, Prod1, Prod2, Prod3, AutoID FROM RecordProduction WHERE (Department = @PrmDepartment) AND...
2
by: jw01 | last post by:
I have a form in which there is one combo box and three text boxes: Combo Box: -> Item A -> Item B -> Item C TextBox1: TextBox2: ...
7
by: tranzit | last post by:
hi i have a form with a combo box and two text boxes on it. i want it set up so when a selection is made from the combo box the two text boxes will display the corresponding data from the table. ...
2
by: Dave | last post by:
I have 3 tables of information feeding into 4 combo boxes on my main form (DR Form). I have as many list boxes (acting as text boxes) as there are fields in each one of the 3 tables. Once...
12
by: Lnwolf | last post by:
Hello, I am having an issue with my synchronized combo boxes and don't know how to fix it. I have created two boxes and have made the synchronization work (the user clicks on the first box and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.