I have set several tables up in Access 2013 that all work fine along with their relationships and look ups. I have a particular issue that I cannot resolve.
Tables
CUSTOMERS
CustID which is unique example ABC001
CustName example Acme Construction
etc
BRANCHES
BranchID 2(X)
CustID...