Two Table Link Problem 1

[robcarr]

Hi,

I have 2 tables 1 called tblloggeditems and tblclosedas

I have a form to enter data in, all data except the closurereason goes into tblloggeditems.
Closurereason goes into tblclosedas - this is because each case can have multiple closurereasons. When I try to run a query or anything on the 2 tables, it always says data type mismatch, the connecting field for each table is UniqueID, what I am trying to do is link my tables correctly, so when I run a query on an agent i can view all records for that agent and show all the closurereasons they used for that case.

but i just cannot get it to work, this is why i posted in tables and relationships as I think this is where I have gone wrong.



Hope this is of use, Rob.

 

[PHV]

the connecting field for each table is UniqueID
What are the data types of tblloggeditems.UniqueID and tblclosedas.UniqueID ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[robcarr]

uniqueID tblloggeditems - autonumber
uinuqie tblclosedas - text

i see this may cause a problem, but how would i get around this,

Hope this is of use, Rob.

 

[PHV]

It should be Number (Long) in tblclosedas.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886