Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Spouse Relationship & Anniversary

Featured Replies

This is the database structure as I have it. 

Account ---< People 

There could be several people related to an account originally i had their anniversary date stored in each persons record however I have seen incomplete information or mismatched information, plus it required a duplicate entry on two records. 

So then I figured we only need ONE instance of this anniversary date so i could store that in the main account table, and also a flag if they wish to receive an anniversary card.

But now i need to link two individuals together so that I can derive the names to put on the card & envelope.

And also break the link when one of the individuals pass away so as not to send them an anniversary card posthumous. Or at least un-flag the record to send a card, the link and date could remain, as there are cases where I need to send documents to the surviving spouse and add the phrase "Estate of" for the deceased. 

I was thinking of just a text field in the account table that would contain a return separated list of the UUID for the people. But this could be harder to deal with if I need to do a n SQL statement with it. Or possibly a spouse_one & spouse_two field - not clean or ideal...

suggestions welcomed.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.