table and query relationship

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Souris - 26 Feb 2008 16:39 GMT

I want to build a relationship between a query and a table.

MS Access allows me to create a text(4) in the query and an integer field in
the table.

Does it make sense for this?

Will it have any problem, since text(4) may have characters, but not integer?

Can I do this, because access allows me to do so?

Your information is great appreciated,

Reply to this Message

John W. Vinson - 26 Feb 2008 20:09 GMT

>I want to build a relationship between a query and a table.

Access will not allow such a relationship to be enforced.

>MS Access allows me to create a text(4) in the query and an integer field in
>the table.
>
>Does it make sense for this?

No. The datatypes must match.

>Will it have any problem, since text(4) may have characters, but not integer?
>
>Can I do this, because access allows me to do so?

Well, maybe I don't understand. How are you attempting to create the
relationship? Could you post the SQL of the query?

Signature

John W. Vinson [MVP]

Reply to this Message

Souris - 27 Feb 2008 02:05 GMT

I have an employee table which has login filed as text (4)
I have alogin table has login table Login ID as integer.

I have a EmpLogin Query select Employee ID and Login Id

I tried to link relationship between EmpLogin Login filed which is text(4)
to Login table Login which is integer.

MS Access does not conplain and let me to do it.

You can a test to link a query and table filed in different type to see does
Access allow you to do it.

Thanks again,

> >I want to build a relationship between a query and a table.
>
[quoted text clipped - 13 lines]
> Well, maybe I don't understand. How are you attempting to create the
> relationship? Could you post the SQL of the query?

Reply to this Message