You will probably be tempted to use CFFORM and CFSELECT to do this. The bind parameters make it easy. But I would advise against using CFFORM. I know of no veteran developer who uses CFFORM (unless there's one, here, who isn't telling me.)
Thank you for your reply.
Indeed,I used a cfform! [ ]
Can I please havean example because I am a beginner.
Thanks in advance.
I intend no offense, ZNB, but these forums are for helping troubleshoot code that isn't working. Occasionally, if a request is small enough, someone might write it all out. But what you are requesting is a bit bigger. We are not here to write code, for you. Especially if it's for homework, which I'm getting the distinct feeling that is why you are asking.
Perform a Google search for "related selects" and view the sample codes that you find.