Retrieving Data From Another Table

[cyliyu]

Hi,
I am new to MS Access, I have created 3 tables, tblDefect, tblCar and tblDesc.
I also created a Form to input data into tblDefect, I would like to auto-insert some of the data from tblCar and tblDesc when the fields match with the tblDefect.
Is it possible? I try to google but not sure what are the correct description for this action. Thanks.

 

[pbaldy]

I suspect you mean this, but note the caution against storing the same thing in two tables (other than the key field):

Autofill

 

[arnelgp]

your tblDefect should have:

CarID (long)
DefectID (Long)

table Car:

CarID (autonumber)
CarName (string)

table description:
DescID (autonumber)
Description (string)

bound the Form to tblDefect.
your form at least, must have:

Car (combobox)
ControlSource: CarID
Rowsource: tblCar
Number of column: 2
Column Widths: 0; 1"

Defect (combo)
ControlSource: DefectID
Rowsource: tblDescription
Number of column: 2
Column Widths: 0; 1"

 

[cyliyu]

Thanks, Paul.
It is Autofill to display the info from another Table but not to save it to avoid storing the same thing in 2 tables.
e.g. I have the tblCar that predefined and stored 3 fields, CarNo, CarType, CarDes.
So when CarNo in the Form was key in, I want CarType and CarDes to be auto display in the Form to the user.

I will try the command in the link provided and see how it goes. Thanks

 

[pbaldy]

To be clear, you want the first method, not the second.

 

[cyliyu]

To be clear, you want the first method, not the second.

That is correct.