table

  • Thread starter Thread starter Stanis
  • Start date Start date
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?
 
Hi,

You cannot and select and copy in one SQL statement. On the other hand,
the operation copy is probably useless, make a join:

SELECT table1.*, table2.*
FROM table2 LEFT JOIN table1 ON table2.Model=table1.Model


and use THAT query, rather than one of the two tables.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top