Auto filling field with data from different table

[rhay]

Ok, I apologize for all the questions tonight but I am running into things I can't find an answer on through web searches etc.

I have a db with 2 tables and 2 forms.

1 table has personal info of my soldiers.
1 table has info on each crew. ( A crew is 4 soldiers).

Here is what I need to do.

I have 4 unbound text boxes on the crew form, I need to fill them in with the serial# of each soldiers weapon on that particular crew.

The fields in personal table I think I need to work with are:

Weapon Serial No
Crew
Position

I have a relationship between the 2 tables based on the field "crew"

I want it to be able to look at "crew" then "position" and based on that, fill in one of the unbound text boxes on the form in the crew data table with the weapon serial # of one of the soldiers on that crew and repeat it for each soldier on that crew in one of the unbound text boxes.

Does this make sense?

Thanks,

Robert

 

[mingram]

If I understand you correctly, what you need to do is go to the table that have the field of the soldiers numbers and under "datatype" select "Lookup wizard" and that will allow you to enter the numbers and when you are on a form you can add also to the list box. By doing it this way, you will not need to use unbound list boxes, just drag that field from the list box and then go to form view and when you pull it down you should see your list.

Hope it was helpful