AnsweredAssumed Answered

Comparing one field across two different tables (layouts)

Question asked by MartinReid on Mar 26, 2013
Latest reply on Mar 27, 2013 by philmodjunk

Title

Comparing one field across two different tables (layouts)

Post

     Hi, 

     Was wondering if anyone knew a way to comparing or even search across to two different layouts to find if data has been entered twice?

     A bit of background, i have two layouts that contain information, but the second table is amde up from information from the first. the problem is I have many people accessing this one file and updating it and if one unobvlivious user enters the information back into the first table then when end up with duplicates, which doesnt help is the database is up to 50,000 records.

     Thanks
     Martin

Outcomes