Relationship not seen when trying to create new column

[Anonymous]

Hi,

I am trying to troubleshoot an issue with a relationship.

I have two tables, one with PART #s and a costing Plan, and another with PART #s and actual sales data. I would like to link the two based off of the PART#. I am trying to create a new column in the sales data table, and reach out and grab information for those parts in the costing plan, but it won't let me.

A couple bits of info that may be screwing it up:

* Each sheet has parts that the other doesn't in it

* When trying to manage relationships, it will only allow me many to one (cardinality) from costing plan (many) to sales data (one).

Thank you for any help in advance.