id number

[brino]

hi all !

i have a form where users select a persons name from a drop down
list.
when selected the persons name goes into a field in a table.
this list of names comes from another data base that i've connected
to.
when the user selects a name i want the persons ID number to go into
an ID field as well as there name going into a name field.
how can i do this ???
any help would be great !!

thanks
brino

 

[Guest]

Hi brino,

If you have an ID field related, you don't want to store the person's name
in the table also. Simply follow the link (via the ID field) to the Person
table to get their name.

Hope that helps.

Damian.

 

[John W. Vinson]

hi all !

i have a form where users select a persons name from a drop down
list.
when selected the persons name goes into a field in a table.
this list of names comes from another data base that i've connected
to.
when the user selects a name i want the persons ID number to go into
an ID field as well as there name going into a name field.
how can i do this ???

Well... DON'T do this.

Relational databases use the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place". The person's name should be
stored in the Names table, and *ONLY* in the Names table.

Your table should store the ID (by making the ID the Control Source and the
Bound Column of the combo box); you can *display* the name by a Query linking
to the names table.

If you want to select a subset of the names and ID's from a remote database
that you won't have online routinely, then an Append query would be your best
bet.

John W. Vinson [MVP]