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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Hi

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.

Thanks
Photo of Ashley

Ashley

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of John Thomas

John Thomas

  • 1,062 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.
(Edited)