Forum Discussion
QuickBaseCoachD
Qrew 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.
MikeRuoppoli
7 years agoQrew Member
I have something similar i am trying to accomplish.
Tables and relationships
Accounts with many Contacts
Accounts with many Sales Activities
Contacts with Many Sales Activities.
I would like to have a Contact pick list when adding a new Sales Activity (ie sales meeting) to an Account . Like selecting all of the contacts that were in a meeting.
Suggestions?
Thanks
Mike
Tables and relationships
Accounts with many Contacts
Accounts with many Sales Activities
Contacts with Many Sales Activities.
I would like to have a Contact pick list when adding a new Sales Activity (ie sales meeting) to an Account . Like selecting all of the contacts that were in a meeting.
Suggestions?
Thanks
Mike