one relationship is creating but other is not creating

[trkl]

the 1st relationship was created ok but the 2nd wasnt possible.. http://www.4shared.com/archive/Y5xJHsKW/GEM.html" target="_blank">http://www.4shared.com/photo/sZVexLmE/GEM.html ms access 2010 doesnt create relationship b/w following tables plz click below to see tables,their relationships and their fields list . relationship was created b/w primary Guest and Related Reservation Table,but between primary property and Related Reservation Table. it gives following error mesage. Relationaships must be on the same number of fiedls with the same data types.

 

[trkl]

above link is in compressed form

 

[Pat Hartman]

Did you check the data types?

PropertyID in the property table should be defined as autonumber (if that's what it is). PropertyID in the Reservation table should be defined as long integer.