Relationship between Table A and B without using Primary Key on table A

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress

I have a table called Leads. The primary key on this table is the "Record ID#" field. Leads eventually open accounts and the Lead records "Account Number" field gets updated with the account number of the account they opened.

Im trying to build a relationship between the Leads table and Sales table. the Sales table contains the account number that places orders with us, the relationship needs to be between the Account Number field on the Leads table and the Account number field on the Sales Table, neither of these account number fields act as a primary key.

Is there a way to do this? Essentually i want to be able to have fields on the Lead table showing the number of orders placed and total sales number taken from the sales table.

Photo of Ashley


  • 70 Points

Posted 2 years ago

  • 0
  • 1
Photo of John Thomas

John Thomas

  • 1,082 Points 1k badge 2x thumb
Without a relationship , I think you can use a report link. Based on the fields you can make the field relationship on the field properties.