I am a relatively new user of FM, and have been tasked with developing a data base for a volunteer run archive. This archive manages the history of Australian Jazz. To date it has used a rudimentary data base to record the 10,000 objects in the archive. The objects are music disks, CD, Videos, Reel to Reel, Acetate, LP etc
The contact data base consists of Members, Volunteers, Musicians Donors and Sponsors
The Entry level Contact form automatically provides an ID for each contact. It has Radio Buttons to determine whether the contacts are Members, Volunteers, Donors, or Musicians
A tab form allows the user to then input specific data related to either Member, Volunteer, etc
I would like to create an individual ID for each of the sub units (member, donor, volunteer, etc) The automatic entry of this number is dependent upon whether the contact has ticked the box for that skill set.
So how do I go about this
Obviously, if I use the Auto Entry, it will need to be validated to ensure the contact has ticked the relevant box. I have tried to use a Calculation to define the Validation, but it does not work.
Can anyone please help?