Automatic data insert into several fields by using one field

C

carolerandy

I am trying to have it so my data base will be able to place all
required information into certian fields by inserting on piece of
information.

This involves one db with the information being placed into a form is
there anyone who maybe able to assist me.
 
J

John Vinson

I am trying to have it so my data base will be able to place all
required information into certian fields by inserting on piece of
information.

This involves one db with the information being placed into a form is
there anyone who maybe able to assist me.
Click to expand...

Please post a bit more of the context. It sounds like you want to get
data from one table based on some unique value, and store that data
redundantly in another table. If so, that's a VERY bad idea.

please explain where the data will come from, and where you want it
put.

John W. Vinson[MVP]
 
C

carolerandy

Currently I have a personal table with multiple headings. What I would
like to do is take some of this information ie. Last Name, Rank, MOC,
Coy/Secton and have it automaticaly placed in a form that has the
same fields. I would do this by typing in the SN which is unique to
each individual. This would all be within the same db.
 
C

carolerandy

Currently I have a personal table titled 2 Svc Bn Pers with multiple
headings. What I would like to do is have the following information
automatically entered into fields on the form Called Sick Parade ie.
Last Name, Rank, MOC, Coy/Secton. I would do this by typing in the SN
which is unique to each individual. This would all be within the same
db.
 
J

John Vinson

Currently I have a personal table titled 2 Svc Bn Pers with multiple
headings. What I would like to do is have the following information
automatically entered into fields on the form Called Sick Parade ie.
Last Name, Rank, MOC, Coy/Secton. I would do this by typing in the SN
which is unique to each individual. This would all be within the same
db.
Click to expand...

If you just want to DISPLAY the name, rank and so on, you can include
all of these fields in the Row Source query of a Combo Box based on [2
Svc Bn Pers]. On the Form, you can then put textboxes with Control
Source properties

=[comboboxname].Column(n)

where (n) is the zero based subscript of the field you want to see -
that is if the Rank is the third field in the combo query, you'ld use
(2).

If you want to *STORE* the name, rank, etc. in a Called Sick Parade
table - reconsider. It is neither necessary nor wise to store this
information redundantly in a second table. Just store the SN and use
the combo box trick above, or a Query joining the two tables, to bring
the information together.

John W. Vinson[MVP]
 
Top