how do you get tables to autofill with relationships? 1

[reapershole]

i have several tables i am working with. what i want to do is take the main table...

Chacter Information (title)

Character ID
First Name
Last Name
Middle Initial
Address
City
State

I have other forms which will have this information and more. I want to be able to select the Character ID and have all the other subsequent data (First Name, Last Name, Middle Initial, ect, ect) all self-fill. I have seen this done in tables before, but I never though to see or ask how it was done before.

I really need help here... PLEASE.

 

[mas5]

How are you selecting the Character ID? Is it a combo box or a list box? If so, you can fill in your form fields from the fields in the combo box/list box.

In your combo/list box select all the fields that you want, but only display the characterID or other identifying character. Then, after the user does the selection (on click or on exit when you have determined the selection) then fill in your other fields.

So if your combo box select statement is:
Select characterid, firstname, lastname, middleinitial,
address, city, state

once you've determined the selection, fill in the fields on the form as follows:

me.characterid = me.combox.column(0)
me.firstname = me.combobox.column(1)
me.lastname = me.combobox.column(2), etc.

Is this what you were looking for? I wasn't sure if you are really talking about filling in other tables or forms. You really shouldn't be carrying around the same data on multiple tables. The characterid should be sufficient to link to the other data.

 

[reapershole]

it did work very well but in considering your comment that i should not be doing that i sat down and too another gaze at my work and deleted a good 3/4 of it. i do still have one table that is access info off of the main table in the fashion you dictated and i thank you very much for the aid!