problem with data

[erminm]

In the form of the input costs of fuel in one field are drawn vehicle information from another table, when choosing a vehicle and save the data in Table I by typing the values ​​of ID in front of the data from the vehicle, in the field we show that the vehicle but the table ID is entered.:



plss hlp

[alansidman]

Perhaps an example with sample data of what you are trying to do. What results you are getting and what results you are expecting. Your run on sentence is very confusing.

Indicate field names, table names, etc.

[erminm]

ok I have 2 table, first iz vehicle and secund is fuel. In table vehicle I have columns: RB, name_vehicle, type_vehicle..in table fuel I have columns: name_vehicle, quantity, price. So name_vehicle is from table vehicle and program write every time in filed name_vehicle RB from vehicle . When I create Report from fuel, I get in field name_vehicle RB......

[alansidman]

What is RB? Is that the Record identifier? Also is it the primary key? In your second table, is the name_vehicle field a combo box on your form?

Is the report your are trying to run based upon a query based upon one or both of the tables? On which fields are the tables joined?