Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
To actually create 100 Activity records quickly is possible to do, but you would need to contact me off line for help setting that up. I think that the design of your tables and their relationships will need to be adjusted.
I tnink that it will need to be something like this
One Company has Many Contacts
One Contact has Many WorkShop Attendances. ie indicating that a particular Contact attended a particular session of a Workshop.
One Workshop Session has many Workshop Attendances
One Workshop has many WorkShop Sessions (ie the same basic course is probably run on different dates.)
You may want to have a button which automatically creates the detailed 100 WorkShop Attendances for all Contacts at a company, and then you would just adjust those 100 for say a few people who missed that session due to illness or travel commitments. Alternatively, you will need to create those 100 Workshop Attendance records manually.
I tnink that it will need to be something like this
One Company has Many Contacts
One Contact has Many WorkShop Attendances. ie indicating that a particular Contact attended a particular session of a Workshop.
One Workshop Session has many Workshop Attendances
One Workshop has many WorkShop Sessions (ie the same basic course is probably run on different dates.)
You may want to have a button which automatically creates the detailed 100 WorkShop Attendances for all Contacts at a company, and then you would just adjust those 100 for say a few people who missed that session due to illness or travel commitments. Alternatively, you will need to create those 100 Workshop Attendance records manually.
olivermah
8 years agoQrew Assistant Captain
I am trying to do the exact same thing. Has anybody shed further light on this?