hi i am working in the audit database and i am stuck in one point, in my database i have three tables as follows.
1. audit with fields audit_id,audit_title etc (in this table i register the new audit for the company)
2.standards with fields standard_id, standard (this is the static table with predefined standards like national, clinical, non-clinical etc)
3.audit_standards with fields audstandid, audit_it , standard_id (this is the table in wich i store the standards against order selected by the user. there can be more than one standards against one order.
for this i have list box bounded to my standard table. user selects one or more standard from the list and the values are inserted in standard_detail table against that audit. until here it works fine.
the problem is with the updating of the audit when user reopen that audit. i can't find the way how to populate my list with contents of the standard table (ie with all standards) and highlight those standards already selected by the user which are in audit_standard table, i mean if list is loaded the standards is audit_standard shold already be selected in the list and the user shold be able to deselect them or add the new standard against the audit.