Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Self checking field

Author  Topic 

bhavoo
Starting Member

5 Posts

Posted - 2007-11-21 : 11:37:43
Hi,

I have a table in one of my databases with a lot of bit(true/false) fields. I have an asp page that selects an individual student then you can tick off attributes (subjects) once they are completed. Basically a big tick list.

I want one of the fields called certificate to be selected when all of the other fields have been checked. How can I do this all on one page? I am using visual web developer express and SQL server 2005.

Here is a shortened down table. Let’s call it options.

pupilid varchar 255,
excel bit,
mindmapping bit,
word bit,
certificate bit.

So the user can check the values using the grid view I have created. Then once they are complete the field certificate automatically fills in.

Thanks,

Bhav

cognos79
Posting Yak Master

241 Posts

Posted - 2007-11-21 : 11:39:13
This is more of a front-end issue.
Go to Top of Page
   

- Advertisement -