Error Looking Up Value for Access 2013...

[sfqfj]

Table Relationship:




I can't seem to be able to get the Item1Cost and Item2Cost from their respective table.

I've tried this:


I've also tried using the lookup wizard for the table Combine but
it just create a new relationship.

Can anyone shed some light on this?

[ItsMe]

Why are you trying to create a Key relationship on Cost? Just use the one Primary Key Relationships on ID/Item1 and ID/Item2