I have a question.
I have three tables for example, person, skill, person_skill.
I have to create update function using coldfusion.
I have to display a check within the checkbox for which skill that a selected person already has which means on the first page, I have to enable user to select which person's information the user wants to update. Then next page I have to display that person's information. For example, person a has skills in Visual Basic, C++. Then there is a check in the check box next visual basic, and C++. Other skill checkbox such as coldfusion, html, do not have check in the checkbox next to them.
Does anyone know how to tell the code to look at every record of that person in the table person_skill and display only one checkbox next to every skill no matter that person has that skill or not. The difference just is to show the check or leave the box blank