mwood1
03-08-2005, 06:25 AM
Hi all,
im having real problems with the attached search form. I have one table in a database called 'Personnel' which i can search on with no problems. For example i can search on just a persons name or a persons name and office. However, i then have a specialist table which i need to search on either on its own or with an attribute from the personnel table ie if i wanted to find a person called john wqho specialises in discrimination. I have attached the code and the table relationship diagram (ERD) for anyone that can help. Im at the end of my tether with this!!
thanx in advance
im having real problems with the attached search form. I have one table in a database called 'Personnel' which i can search on with no problems. For example i can search on just a persons name or a persons name and office. However, i then have a specialist table which i need to search on either on its own or with an attribute from the personnel table ie if i wanted to find a person called john wqho specialises in discrimination. I have attached the code and the table relationship diagram (ERD) for anyone that can help. Im at the end of my tether with this!!
thanx in advance