table and query relationship

  • Thread starter Thread starter Souris
  • Start date Start date
S

Souris

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,
 
I want to build a relationship between a query and a table.
Click to expand...

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?
Click to expand...

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?
Click to expand...

Well, maybe I don't understand. How are you attempting to create the
relationship? Could you post the SQL of the query?
 
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,
 
Back
Top