How to do this with webassist extension ???

I have two Mysql datatables, one is client,the other is clientrelationsip table .
The Client table records the client’s information , such as telephone number ,address ,besides it has one column `HOMENumber`which is the same value with PrimaryKey which is auto_increment . I complete this by dataassist without any pain.
Therefore,Some of my clients are families. So the clientrelationship table is used for recording the client’s relationship. It got 4columns,”CRID”,”PrimaryclientID”,”AddonclientID”,”relationshiptype” ..
The CRID is auto_increment and PrimaryclientID is the primarykey of a client in client’s table ,and AddonclientID is another client’s primarykey in client’s table and relationship column records the relationship between the PrimaryclientID and AddonclientID, such as father ,mother ,son,daughter…etc .
Client_Results.php generated by WADA will “transfer” the PrimaryclientID in URL premeter to the Client_FamilyRelationship.php which I made by myself , then the page will show the Chosen client’s Name,Telephonenumber,address to make sure which client is chosen, and below the information table (the Chosen client’s Name,Telephonenumber,address), I make a table with repeat region to show all customers except the primary client .
Question:

The table got 4 column FirstName LastName Relationship and “check box” .
The relationship column is a drop_down_menu which has father,mother…..etc,and the checkbox means when it is checked , this row of client has relationship with Primaryclient …
Maybe only one client will be “checked” or many clients will be”checked” .
The Server behavior is insert the data I chosen into the clientrelationship tabe and update those addonclien’s “HOMENumber” the same with primaryclient’s in client table . Of course I should have the ability to delete update the records in clientrelationsip table , So is there anyone can help me?? Or can I use WADA to complete this work??

I think you can make use of the manage relational data server behavior in DatAssist to manage this linking table based on the values that you select in the form. If you have not tried using this server behavior I would suggest taking a look at it from the help to see if this will fit your needs. If it looks like it might you should make a backup of your pages and test out the manage relational table server behavior.

This server behavior will do just what it's name says, it will allow you to make some selections and have the joining table updated based on the values you are selecting. There are some threads here on the forum that deal with using this server behavior that you may find very helpful.