> Does anyone know how to use a check box to select
> multiple records in a
> table? I need to check or select more than one item
> from a list and then
> use the selections in an application.
I have an enhancement request in for a CHKBOX2 style
option to the CHOOSE command that would allow exactly
this (check box menus that work like the current ones
but put check boxes next to the records instead of
highlighting the selected ones). I wouldn't expect to
see an enhancement of that complexity before version
7.5.
In the meantime, here are two methods:
1. Use the existing CHKBOX option on the CHOOSE
command, which lets you SHIFT-CLICK to highlight more
than one item.
2. PROJECT a TEMP table of the records from which you
want to select a subset. Add a Yes/No column to the
table. Then, use a simple form with a check box
attached to the Yes/No column to let the user mark the
records. Now you can identify the records using
SELECT * FROM OriginalTable +
WHERE UniqueID IN +
(SELECT UniqueID FROM TempTable +
WHERE YesNoCol = 'Y')
--
Larry
