Hello!
We have been on v11 for about 2 months now and have noticed that the name_ind in T_AFFILIATION for A2 is sometimes set to 0 rather than -2 for HH accounts.
When I go into these records in the client to try and update them, I am unable to. Of course I can update them via SQL, but it would be great if end uses were able to do this, or if it didn't allow you to save the record at all if this is missing from an Adult Affiliate record. It causes problems when writing queries as I am unable to rely on this field.
Anyone else had these issues? Is there a way to update these on the front end?
Natasha
Hi Natasha -
That column SQL is mirrored by the None/A1/A2 indicator on the affiliation record itself and controls whether that affiliate is considered when building household salutations.
You can edit this via the front end by editing the actual affiliation in the relationship tab. Once you set the A1/A2 flag and save the account on the general screen, you can only edit from the relationship tab.
HTH,
Heather
Makes perfect sense! Thanks Heather. Salutations is precisely what I was having issues with....