Subject Re: [firebird-support] Re: Update Table
Author Martijn Tonies
> Marcelo Machado wrote:
> > I know, but I´m working with orthopedic specialists, they love the
> >
> > 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"

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

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!