Hi, I have queries regarding Database design in sql server 2005. I have Book Library. I have a master where i am storing different category of writers for eg. Story Writes, Poets, Technical writers, Fiction Writes etc. For eg. I have stored Louies David who is a Story writer as well as Poet. I want to develop a search for above category for selected name or populate a list box for single category. I have also another processes like contract for Books which is in transit but need to store details in Database. for eg Book Contract. It is having status as 'Approved' or 'Transit'. But i Need to store the categories and name of the writes in the database as well. I have created Writes Category Table with Metadata for eg, 1) Table - WriterCategory WriterCatID int - not Null WriteCategory - int - metadata value ( Binary number for eg. 2) then for next record it will be 4, next will be 16 .. as so on. CategoryDescrition - Varchar(50) - for . eg. Story Writer 2) Table - WriterMaster WriterMasterID - int WriterName - varchar(50) for eg, Louies David Metadata Total - metadata which is selected by user for eg. He is Storywriter + Poet then 2 + 4 = 6 will be stored in this table 3) WriterMasterDetail WriterMasterDetailID - Int WriterMasterID - FK of WriterMaster Metadata - individual category Number stored in WriterCategory From above Table i can populate list boxes for categories as well as from Name i can find the category of the selected name. But when I want to this to be also get values for BooKContract then I should i stored the value. Should i go with same Masterdetails Table ? The above design was to reduce table for each categories and redunant data. I want to maintain the same thorugh out the application ? I will have to store each CategoryID with WriterMasterID for each contract and will have to retrive with query which gives with multiple records along with metadata. I realised that i will have to first find the distinct name and then iterate for type of metadata to store BookContract. Can u please suggest ? Do I need to stored each WriterMasterID for each category as column in table? Please suggest better solution. Thanks in Advance.

How do I check that or restrict the row to be selected if same row is modified by other user. For eg. I have created following table. Consider below tables; 1. Bills Table Fields Description BillNo - Bill No Unique (Primary) - No duplicates allowed. Customer - Customer Name -Non Blank BillAmt - Bill Total -Not Empty & Only Positive Values Collected - Collection Done against this bill No Negative Values & shud never be more than BillAmt 2. Collection Table Fields Description RcptNo - Receipt No. Unique (Primary) - No duplicates allowed. RcptAmt - Receipt Total - Cheque / Collection Value. 3. Col_Ref Table - Collection Reference, A Child Table for Collection to store its referred (multiple) bills. Fields Description RcptNo - Receipt No. Unique (Primary) - No duplicates allowed. Ref_BillNo - Referred Bill No. Ref_Billamt - Referred Bill Amount I have some records. for eg. 1) I have Bill no. 00001 with amount 10,000/- in Bills Table. At the same time another user is accessing Collection Table and referring the same Bill no. and accepts receipts and updating amount in Collection table in Bills table. If user is accessing Bill number he will not get actual amount of collection so i want to restict user for viewing the Bill number which is getting modified by another user using Receipt option in web application. The back end will sql server 2005. How do I do that ? Before allowing the Edit, Check if the record this invoice is not locked, only then lock the same & allow editing of this entry only for the Invoice Amount & later on <> / <> release the lock. Otherwise Pop message "Update is in progress for this entry, try again later..." Please guide. Thanks in advance.

I have Dropdownlist and onSelectedIndex I want to fill another Dripdownlist ( ASP control ). How to implement the same. With HTML button control Javascript is possible but how about this? I do not have Ajax control.