[AccessD] checkbox concatenation

Gustav Brock Gustav at cactus.dk
Tue Oct 31 11:09:51 CST 2006


Hi William

That would require an engine capable of bit-mapped indexing and searching.
At least one can do this, InterSystems Caché:

http://www.intersystems.com/cache/

http://www.intersystems.com/cache/technology/components/bitmap/index.html 

/gustav

>>> wdhindman at dejpolsystems.com 31-10-2006 15:47:51 >>>
...given four tables

   tblContact pk ContactID fk CompanyId
   tblCompany pk CompanyID
   tbEvent pk EventID
   tblEventReg pkERID fk EventID fk CompanyD fk ContactID

...tblEventRegistration is a join table to show which contacts from which 
companies attended which events.
...given that thousands of contacts attend each event, tblEventReg is 
growing logarithmically

Q: is it feasible to use a numeric field in the tblContacts to replace 
tblEventReg by using event checkboxes instead, assigning them a numeric 
value by show and then mathematically summing them in the numeric field 
...thus using one integer to represent every event attended by that contact? 
...yes/no? ...pros/cons?

William Hindman 




More information about the AccessD mailing list