for example I have a list of patients with their bed number. I have a table of bed #'s with with details about the bed (Room #, Floor #, Dept etc). When I create the relationship it adds another "link to ..." field. I just want to use the existing (unique) bed number as my link.
Marcus Glynn shared this idea · Jun 14, 2016