Create one to one relationship

[Papou]

I'm creating a database and i've been able to set all my relationship, which are all ont to many, only one is not working which is a one-to-one relationship. Let me explain the context.

I have a table with a list of process(1). I have another table with a list of application(2). Since a process can be related to more than one application, I've created a table that matches process with application(3)and the reationship works great. This table(3) contains 3 fields: a)an auto number field, b) a process number field and c) a application number field. The primary key is field b and c.

Finally I have a fourth table that stores an assessment for each record in table 3. In table I have a field which is the primary key that store the auto number that identify the relationship between process and application (field a), table 3). When I try to set up a one-to-one relationship between these two fields an enforce referential integrity it doesn't work.

Any ideas????

 

[elizabeth]

If I remeber correctly, to set up ref integ the fileds have to be of same type. YOu have autonumber in one table and probably long int int the matching table. Instead of a separate table, can you add the field from table 4 in table 3?