error between two tables

[platinumlofts]

I have two tables. One is a master list it has two fields a “number” and a “name” field.
The second table is entry table it has many field but what we are focusing on the “handler” field. The “handler” field is a combo box that pulls directly from the masterlist. I have set it to look at the “number” and “name” field from masterlist and store the “name” contents in the “handler” field from the entry table. Simple enough! But what is happening is somehow it is sometimes, not all the time putting the “number” number in that field instead of the “name” additionally you cant see this in Access everything looks great when you look at the table. So, I exported it into Excel and thats when I see the number that is associated with the “name” field in that cell. And out of lets say 300 entries it only does it 15 times. But when you go and try to print a report it gives you and error that a number could be in the wrong field, or the data in the field is to long etc., please help

[alcoool]

try to work with relationships like so

first table must contain a ID (or any other name) field set as autonumber
the second table must contain the same field but as a number

if you want 1 on infinite relationships make the ID field from the first table "primary key"

open from the menu the relationships windou and add bouth tables
drag and drop the ID field from first table onto the ID field on the second table

Chek enforce relationships on the window that just apeard and ok

in this way your data from your tables wil be linked