I am trying to complete an assignment for a class.. i have to set up all the relationships between different tables. im trying to connect 'sale_cashreceipt' and 'salesorder' tables by their invoice number. this relationship should be a one to many, but access is saying it is a indeterminate relationship and the "no unique index found for the referenced field of the primary table" error is occurring. the invoice number is the primary key for the sales_cashreceipt table. i have tried many different things, but this is my first time using access so i am pretty confused.
any help would be great! thanks
any help would be great! thanks
