Autonumber Data/Type Mismatch

[burnout]

I have two tables, one has the autonumber column, sysid, and then in the process of updating the database via forms the sysid from one table is placed in another (text format). I thought I could use that to link the tables for queries, but I am running into a data/type mismatch error.

Any ideas to get around this?

Thanks!

 

[Rabbie]

Autonumber field in one table should link to a long integer field in the child table. You cant match number with text efficiently.

Redefine the sysid in the child table andon the form as long integer.

 

[burnout]

thanks so much!