S
Stanis
I have two table..
table 1 with three fields and table 2 with 2 fields
Name|Model|Km Model|Km
field Model in table 1 is combo box with row source:
SELECT [table 2].[Model] FROM [table 2]; when i select a
model from table 2, i want the record with field Km from
table 2 automaticaly copy to record with field Km from
table 1. For example:
table 1: table 2:
Name | Model | Km Model | Km
stan | bravo |100 bravo |100
joy | brava |130 omega |134
toni | vectra|500 brava |130
micra |200
vectra|500
Do i change the structure of table or make query?
table 1 with three fields and table 2 with 2 fields
Name|Model|Km Model|Km
field Model in table 1 is combo box with row source:
SELECT [table 2].[Model] FROM [table 2]; when i select a
model from table 2, i want the record with field Km from
table 2 automaticaly copy to record with field Km from
table 1. For example:
table 1: table 2:
Name | Model | Km Model | Km
stan | bravo |100 bravo |100
joy | brava |130 omega |134
toni | vectra|500 brava |130
micra |200
vectra|500
Do i change the structure of table or make query?