Please Help- Newbie in trouble

[gblaxx42]

I am having trouble with Combo Boxes updating other fields and the previous discussions are confusing me. PLease be easy on me I am not very good at code.

My example is

I have 5 fields, District, City, Conference, Number of Team, Number of Sports.
What I am trying to do is when I select District 1 then automatically City would be entered as Philadelphia, Conference would be Mid-Atlantic, Number of Teams would be 35 and Number of Sports would be 5.

The way I have it set up now is that all of these fields are listed out in one table called City Sports.


Table- City sports
field1-District
field2-City
field3-Conference
field4-Number of Teams
field5-Number of Sports

The form I want it to appear on is called Player Info

Thanks in advance to anyone who can help.

 

[rainman89]

First off, some questions

Can a district have more than one city?

can a city have more one conference?

if those are true then your table structure need a little work..

Table- City sports
field1-DistrictID
field2-CityID
field3-ConferenceID
field4-Number of Teams
field5-Number of Sports

Table-District
DistrictID-Primary Key Autonumber
DistrictName

Table-City
CityID-Primary Key Autonumber
CityName

Table-Conference
ConferenceID-Primary Key Autonumber
ConferenceName

this will allow for easier searching in the long run

 

[ted.martin]

These examples of Linked Combos may help. Look at the code and combo properties.

 

[gblaxx42]

rainman, thanks for the speedy reply. The district can have a few cities and the city can have a few conferences.

 

[rainman89]

rainman, thanks for the speedy reply. The district can have a few cities and the city can have a few conferences.

so then you will have to change your structure to match something like i have written for you

 

[gblaxx42]

If I wanted to type in information as opposed to selecting from a combo, how would I do that?

For example:

Enter a UIC (Unit identifier Code), Paragraph number and a Line Number.

WEHDO22+101+22

From that combination, in Italics, I want corresponding data to automatically fill out position title, amount authorized and amount on hand.

I have a table that Lists all of of these fields called Battle Roster.

tblBattle Roster
UIC
PARA
LNE
Position Title
Amount Auth
Amount On hand

 

[rainman89]

if you base the form on a query, you can use a textbox as the criteria for the query
this would probably be best done with a frm subform combo,


but you can type in the combo and it will go to the record that you want? is there a specific reason you dont want to use the combo?

 

[gblaxx42]

What do you suggest?

By the combiniation of three fields that are found in one table called Battle Roster:

UIC- which I want to be a drop down
Para- which is 3 numbers that are entered
and
LNE- which is 2 numbers that are entered


after which, fields called: Position Title, Auth, Allowed will automatically be filled in.

I need it to populate items on a form called frmPersonnel Tracker, which connects to a table called tblPersonnel Tracker


My Tables look like this

tblPersonnel Tracker
Name
SSN
DOB
UIC
PARA
LNE
Position Title
Auth
Allowed


tbleBattle Roster
UIC
PARA
LNE
Position Title
Auth
Allowed

frmPersonnel Tracker
I want to link the two tables so that I can enter the first three in tbleBattle Roster and it will be entered in the frmPersonnel Tracker in turn being stored in tblPersonnel.

If this is confusing you please let me know, because I am confused

 

[rainman89]

My Tables look like this

tblPersonnel Tracker
Name This is going to give you a problem its reserved. change it to personname or something like that
SSN
DOB
UIC
PARA
LNE
Position Title
Auth
Allowed


tbleBattle Roster
UIC
PARA
LNE
Position Title
Auth
Allowed

frmPersonnel Tracker
I want to link the two tables so that I can enter the first three in tbleBattle Roster and it will be entered in the frmPersonnel Tracker in turn being stored in tblPersonnel.

If this is confusing you please let me know, because I am confused

ok in order to link them you will need some sort of relationship. do you have one set up?

How is personnel and battle roster related in real life? i think what you might need, depending on the situation is battleID in the personnel table, unless you can have more than one person be in more than one battle roster, then you are talking about a junction table

 

[gblaxx42]

I will change name to SoldierName.

In real life the UIC/PARA/LNE identify a job. For example mine is:

PGUAO/203/01 Which Identifies a Platoon Leader (203/01) in Alpha Company (PGUAO)

Now 203/01 with a different UIC (WAAAO) is not a platoon leader.

 

[rainman89]

ok so you should probably have seperate tables for UIC etc... taht way you can link more than one person to a certain UIC

say you wanted to look up all the platoon leaders. it will be much easier for you to do this if you normalize your data. have you read up on normalization?