Success
Thanks so much Eric for your Help,
I have managed to get it to work by creating an additional recordset, adding an additional "person_category" table to filter my people table in my database.
The only thing I need to find out is if webassist products has a way to prompt if the same record is entered twice as you disscussed in your last post.
I'm not too sure how my WHERE clause should look e.g WHERE people.person_id = ?. I'm not sure how to write the "currently selected" sql statement.
I'm also not too sure how to stop processing and return the user to an error page, does dataassist have a feature to do this?
Many Thanks