At 04:24 PM 3/19/2002 -0500, Aaron Johnson wrote: .... >only the type of item selected. These constraints can be singular or >multiple. So on your current example table the 'Last Name' column would >be a link back to the same page that would redefine the select to only >retrieve the Last Names matching your selection. You could then do the >same for 'Birth Date' and 'First Name', these selections would be >compound so when completed you would only see people with the desired >last and first name born on the date of your choosing. You can also >remove a constraint by clicking on the column again. So if you decided >that you didn't care about first name anymore you simply click on a >first name again and the results returned are 'Last Name' and 'Birth >Date' specific only. ....
FYI. Though not documented well or even obvious from looking at the table, the textfields above each column to almost exactly what you describe. They are "filter fields". Type "sm" into the Last Name filter field and you will get back only records with "sm" in them. Stephen
