Includes dates and mention of birthdays, marriages, awards, deaths, achievements, anecdotes, stories, memories, etc
Select The Family Photo Album Below That You Wish To View.
This system of albums is not intended to be a family tree in any way. It may resemble family tree to you,but it is more of a way to categorize the pictures that are closely connected by content.
The name of the project and all references needs to be placed in a variable so that the form can be used for different families.
There needs to be a CRUD style of form control. Password Controlled with an admin override available
The form requires backup and file transfer capacity.
The “Unique Member Core Identifier” (UMCI) is an auto generated field when adding a new record for the first time. That identifier stays with that member forever. Currently the number is based on the first two letters of first name+first two letters of last name+MMYY of DOB+_unique database row number. Example: BRVE1248_00001.
Use leading zeros
The picture uploads needs to be displayed next to the relevant bio information. This need to be downloadable.
The Generation Ref No needs to be and auto-fill field based on an algorithm. It can change based on automatic data updates but can not be editable.
This needs to be validated by matching to nearest relatives.
When a required field is not known, a default value must be auto-filled to force the formulas to work.
The database must be sortable on multiple fields and filterable on multiple fields. Three conditions for each.
The record number must be automatically assigned to new records and remain attached to them. Auto-incrementing. Non-editable 99999 record capacity. Record number may be deleted only when the entire record is deleted from within the administrative CRUD function.
When adding a new record, there should be a data validation rule to find the closest existing data information match ups ….. from previous database records …. and auto-fill as much information as possible …. and make the choices also available … as drop down choices in the appropriate relevant fields.
There needs to be an option to combine databases from identical projects from different laptops etc. This option needs to include both “Update All CRUD Changes” in either direction OR based on latest date.
ADMIN MENU:
Include multi level permissions and rights. i.e., the Admin Module.
Include “Manage Users”
There needs to be a primary “starting UMCI” when setting up the report parameters.
There need to be parameters set for number of hierarchical generations such as beginning and ending, and lateral generations such as beginning and ending,
Create a “temporary” database showing results of the query and produce reports etc.based on that.