AnsweredAssumed Answered

Automatic generation of ID number, upon satisfying a condition from another field

Question asked by whitsend on Jun 21, 2018
Latest reply on Jun 22, 2018 by philmodjunk

Hi

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?

 

 


Regards
Ross Baldwin

Outcomes