sql error results page not displaying data all the time
generated data assist pages , when run resultspage it shows records in database, insert seams to add new records but if you add a duplicate record it throes up an sql error subsequent insert reports the results page shows no records
the database has a unique key based on the SCREENID and SITEID combined see screenshot attached. I am trying to get a singe event for entry. for each SITE & Sreen Combination, if you could think of a different way to achieve same results,
Note there is already a MRT table retionship between sITE & SCREEN.