AnsweredAssumed Answered

Two one-to-many links in two tables

Question asked by Atcha on Jul 6, 2015
Latest reply on Jul 6, 2015 by Atcha

Title

Two one-to-many links in two tables

Post

Hi,

My database skills are a little rusty so I am hoping one of you can point me in the right direction. I have two tables A & B and want to establish two one-to-many links between them using the primary key of table 1 for one link and the primary key of table 2 for the other. I then would like to design two forms, one based on table A with a portal listing the corresponding records from table B, and one based on table B listing the corresponding records from table A. How do I go about this?

Outcomes