I am looking to add a Gender option to our Custom Education Registration forms we have. We have added the gender option to our Custom tab in the constituent record, but we are looking to update it in SQL as well.
Does anyone know where that would live/how we would go about updating the genders in SQL?
Thank you in advance for any input/wisdom!
Hi Kira,
You can update gender in TR_GENDER to match your values. Those will then be available in the Gender drop-down on the General tab.This updates the gender_id column in T_CUSTOMER but leaves the sex column what it was. So (using me as an example) I can have Gender "Self Describe" and Sex "M".
Updating that using SQL is pretty easy depending on how many genders you have to update. I made up the where statement but you can substitute your custom tab values and it does one at a time.
Update T_CUSTOMER
Set gender_id = 1 --whatever you have in TR_GENDER
where customer_no in (select customer_no from LT_SPECIAL_CUSTOM_TABLE where GENDER_ID = 'Self')