The PrimaryKey should be an AutoNumber and the ForeignKey field should be a LongInteger. Is that what you have?
The PrimaryKey should be an AutoNumber and the ForeignKey field should be a LongInteger. Is that what you have?
yes it is long integer
Will the Relationship menu allow you to set up the relationship? If the query is still throwing an error then post the SQL for the query so we can look at it.