[AccessD] checkbox concatenation

William Hindman wdhindman at dejpolsystems.com
Tue Oct 31 08:47:51 CST 2006


...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