Can't display (borrow) data from parent table

Discussion created by goldencode on Aug 16, 2016
Latest reply on Aug 17, 2016 by philmodjunk

Hi, everyone


Let me start directly


I have two tables the parent table has primary key called _pk_customer_id and the child table has a foreign key called _fk_customer_id


I have linked the primary key to the foreign key so the relationship is created. Now the parent table already contains data about customer's name, address, email..


In the layout that shows records from the child table, i have added these fields: name, address, email.. and they are set to display data (borrow) from the parent table.. when i perform "find" using for example email address, i get a message saying that there are no records match!


What's wrong i'm doing with the relationship between the tables?!