> Marcelo Machado wrote:
> > I know, but I´m working with orthopedic specialists, they love the

checkbox!

> >
> > What could I make?
>
> A separate table:
>
> record_id <- pk of original table with 600 fields
> name <- name of checkbox
> value <- is it checked or not?
>
> The table would have 600 rows per single row in original table.

No, actually, the table could ONLY have rows for the "checked"
items.

If there's no row, it's unchecked.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com