Real basic stuff i cant get help

[AlastairH]

trying to join two tables but get message

"relationship must be on the same number of fields with the same data types"
data types are same, numbers.

Primary table has just jobnoID that are all unique (primary table)
ie 6907, 6908, 6909 etc

second table "jobs by order" (secondary table)
has
unique orderno(order numbers) in column one say 69071 and 69072, 69073
and jobno in second coloumn say 6907, 6907, 6907 for all the above.


trying to link JobnoID primary table (one to many) to Jobno secondary table (many)


Also need to note. This database is a purchase order database. so am trying to load in all past data from excel. data is in already. so primary table above with jobno is an auto number so will generate the new jobno for us. but had to copy and paste blank fields into table to get records upto the number we are upto now, ie job number 7112. I have only put data in secondary table for
jobno's 6885 through to 7112, and even some of these have blank spaces.

Any ideas?
Also how do i do a screen capture and dump in here so you can see relationships etc, which would be a whole lot easier to explain. thanks heaps
Alastair

 

[Fifty2One]

to post a screen capture: if you are a windows user, alt + print screen will capture a screen, then you can paste it into paint and save it as a jpg and attach it to a posting.

 

[The_Doc_Man]

The message is telling you that you are trying to link mismatched keys. If one key is a LONG INTEGER, the other key has to be a LONG INTEGER. If one key is simple, the other key cannot be compound. For some reason, it thinks that one of the keys has more fields in it than the other. The error message is fairly specific. Look at the fields involved in the JOIN or in the relationship. If they ain't the same, they ain't gonna talk.

 

[AlastairH]

"The message is telling you that you are trying to link mismatched keys. If one key is a LONG INTEGER, the other key has to be a LONG INTEGER. If one key is simple, the other key cannot be compound. For some reason, it thinks that one of the keys has more fields in it than the other. The error message is fairly specific. Look at the fields involved in the JOIN or in the relationship. If they ain't the same, they ain't gonna talk."

thanks Doc man, the two keys are as i said above "number" ie data types are the same, and i'm not sure what it means when it says the field sizes are different. attached are the relationships window and the two tables with data at begining and end . so still a little stumped
thanks again.
alastair

 

[AlastairH]

Nope sorry i understand what you are saying and all has worked thanks its been a few years so very rusty. all solved
thanks you all very much for your help