data entry form

[jmd0252]

OK,, I have got a data entry form for a table,, one field is a vehicle number. I have a vehicle table, with vehicle number as my primary index,, and I have the relationship defined in the relationship manager. So on my entry form, for my table I want to enter a vehicle number, and then have the program go over, and pull info from the vehicle table, and fill into the entry form, thereby adding data to the new table. So Anyone got any ideas how I get this accompolished?? I have tried making a form, and defining the fields, as being from my vehicle table,, but I get no info, into the new table.

 

[Lilliabeth]

Why would you want the same info in two tables?

 

[jmd0252]

HUMMMMMM,,,, good question,,,, originally,, the operator was entering all the info,, but decided that it would be easier if I could save them key strokes,, but I could always, write a query, and use that "view", for the inquiries he does.