Posted on 2001-09-07
lemme set this up:
tblCustomers: custID(PK), custName
tblAttributes: attID(PK), custID(FK)
<--this table exists so customers may have multiple logins with different attributes-->
<--simply a relationship table with no primary keys, just ties the customer login to its attributes-->
tblCustLoginAtt: custLogID, attID
OK, now all i wanna do is when you are editing a particular customer login, not only show ALL of the attributes that are associated with that customer in the form of checkboxes, but also check the ones that are already associated with the given CUSTOMER LOGIN.
I have done things similar to this in the past, but with radio buttons, where theres only ONE possible match, and i could open 2 recordsets and test to see:
do while not rs.eof
if rs("attID")=rs2("attID") then
<input type=radio name="myAtt" value=<%=rs("attID")%> checked>
<input type=radio name="myAtt" value=<%=rs("attID")%>>
easy enough....loop thru rs and when come to match on rs2 then check the radio button, but now, it seems like i have to have a loop nested inside of another loop....which ive tried many different renditions of to no avail.....
any code examples or even explanations would be VERY MUCH appreciated! thx experts in advance! I would post some code, but im basically startin from scratch here, so pls someone show me the light! :D
giving my max 300pts, cuz id like to get resolved asap!