Can't join two tables in design view - please help (1 Viewer)

[runkris26]

I am trying to join two tables together. Each table has an exact
match. When I a add the two tables, I do not get the "join" line.
I have one of the fields as the primary key. I have tried to manually
add the join line and get an error when I try to run query. Newbie user.

 

[pbaldy]

What's the error? Are both fields the same data type?

 

[MSAccessRookie]

I am trying to join two tables together. Each table has an exact
match. When I a add the two tables, I do not get the "join" line.
I have one of the fields as the primary key. I have tried to manually
add the join line and get an error when I try to run query. Newbie user.

Were you expecting the Join Line to be there as soon as you added the tables? It does not show up until you define it by selecting one of the Common Fields, clicking on it, and then dragging it on top of the other Common Field. As long as the Fields are of the same type, the Join Line will appear.

 

[runkris26]

According to the microsoft Access book (college book) it makes it appear the join line automatically appears, however, even when I manually drag the join line, and run the query, I get "Mismatched data" or something to that effect. Unfortantely I don't have it in front of me. Both fields are numbers. Maybe I entered them as text, would that matter? Sorry if I am being ignorant. This is really driving me insane.

 

[pbaldy]

Numbers are fine (better even), but they must be compatible, so again, what are the data types (and field sizes, if appropriate)?

 

[runkris26]

I think the data types are
NUMBER (FieldSize= DOUBLE), but I need to check when I get home.

 

[runkris26]

The two rows in each table are both called Technician and they both have "identical numbers" in each row. I tried to join them (tech to Tech), primary keys are both same. Does this helP

 

[MSAccessRookie]

According to the microsoft Access book (college book) it makes it appear the join line automatically appears, however, even when I manually drag the join line, and run the query, I get "Mismatched data" or something to that effect. Unfortantely I don't have it in front of me. Both fields are numbers. Maybe I entered them as text, would that matter? Sorry if I am being ignorant. This is really driving me insane.

If you are getting a "Mismatched data" error, then it means that the data types are not the same. Perhaps one is Single and another Doube, or one Integer and another is Currency or a General Number with Decimal.

As pbaldy said above, verify the actual data types and you will probably find that they are different.

 

[MSAccessRookie]

The two rows in each table are both called Technician and they both have "identical numbers" in each row. I tried to join them (tech to Tech), primary keys are both same. Does this helP

Are both of the Technician Fields Primary Keys? I do not believe this is allowed.

Correction: I have located an example where linking two primary Keys was allowed, along with an explanation that one table had been broken into two parts and the join was in order to allow all of the fields to be considered at one time.

 

[runkris26]

Thanksfor all the answers. I tried all different ways for the primary keys. Nothing works. The only thing is I haven't not checked data types and will be doing that as soon as I get home tonight. 6:00 (EST), I will be trying that first.

 

[runkris26]

Thanks so much, it was the data types.

 

[MSAccessRookie]

Thanks so much, it was the data types.

I find that it usually is the case. Glad we could assist.

 

[runkris26]

Who are you guys anyway? I may have more issues......

 

[MSAccessRookie]

Who are you guys anyway? I may have more issues......

Who are these masked banditos, riding in the night to right all MS Access related wrongs?

No one actually knows, but fret not, because there is really no need to know. There are many of them, and they will always be here to assist people that are seeking help to move along the path of MS Access Enlightenment. All you need to do is come here and ask for help.