hello
I have discovered a glitch in staff members application that I have been working on.
Thought I had everything working smoothly using to tables staff and positions. I have used this data base query to display the profiles
"SELECT * FROM staff, `position` WHERE staff.position_id = `position`.position_id ORDER BY staff.position_id"
Everything works great ... except when a position is removed from the position table and a staff member is still assigned to that position.
My thinking is to write some code that recognizes a staff member is associated with the position that is about to be deleted, but not sure how to go about it.
However, the main problem is that if a staff member is still assigned to a position that has been removed their profile will not display. How can check to see if a staff position exists and then matches what has been assigned to a staff member?
Dave
