indeterminate relationship

[imuharram]

I started developing small database and forms to help us at work in creating work orders that we use.

I have 5 tables:
1. employee (emp) table
2. department (dept) table
3. unit (unit) table
4. transaction (trans) table
5. transaction detail (trans_detail) table

I have four department, and these departments has two or three unit under it.
A work order could be sent to more than one department, and to the same department to two units from that department.
When I try to make the relationship between the tables, it says that the relationship between the unit number (unit_no) in the unit (unit) table and the unit number (to_unit) in the transaction detail (trans_detail) table is a indeterminate relationship.
How could I solve this problem?
(Attached is the database I'm working on)

 

[MagicMan]

When creating the relationship, I think you want to have both Dept and Unit as part of the releationship. I also question the order of dept and unit in th unit table, should dept not be ahead of unit? I created a relationship as above with referntial integrity.

 

[imuharram]

When creating the relationship, I think you want to have both Dept and Unit as part of the releationship. I also question the order of dept and unit in th unit table, should dept not be ahead of unit? I created a relationship as above with referntial integrity.

It worked
Thank you

 

[MagicMan]

Glad to help and welcome to the forum!
Smiles
Bob