How can I stop duplicate entries in a portal?

Discussion created by mikee7 on May 6, 2014
Latest reply on May 7, 2014 by mikee7

Hi I am working with a real mess of an Access database - 15 years old and never serviced, well actually 5 databases in total - and I am attempting to get it into a lovely and easy to use Filemaker system for a client. After a couple of weeks of effort, I am nearly there but the only way I have been able to get my data where I want it to be is to access data from two tables via one portal. This works and gives me the data feed I want but it is duplicating the results in the portal. This is probably because the portal is accessing two tables at the same time but it is the only way I can get the data I need to show. Is there a way to remove the duplicate line? Having gone from Filemaker 6 to Filemaker 13 in one step, I have a lot to learn so some help would be really appreciated.