I wish to create standardised data tables universally built so that they are set for global usage.
They also need to pass only the index id on to to the nested table which shall be used to then collate in sets etc so that no sorce content is held in the set only a number which through a nested trail points back to the original table
this would have the benefit of less duplication, faster processing and better security
ie
Standard Table (ST1) has Male_Forename_ID and Male_Forename fields
00001 Alfred
00002 Fred
00003 John
Standard Table (ST2) has Female_Forename_ID and Female_Forename fields
00001 Amy
00002 Frances
00003 Joanne
Standard Table (ST2) has Surname ID and Surname fields
00001 Smith
00002 Jones
DataBase Tables used in Application would be:-
MFID FFID SID
Male_Forename_ID, Female_Forename_ID and Surname_ID
00001 00001 00001
00002 00002 00002
00003 00003
the resultant Database Sub-set created for - Lets Say - a Client would be composed of the either one or more Male_Forename_ID's or Female_Forename_ID's added to a Surname_ID this would then, through pointers be identied back to the source files and would only then when require upon a call uperation display the result held by the source files which would be relevant to the combined SET_ID's
ie
Taken from FFID & SID
an ID = 00001+00001
Client_ID = 0000100001
would result in the name Amy Smith being displayed
whereas:-
Taken from MFID & SID
an ID = 00003+00001+00002
Client_ID = 000030000100002
would result in the name John Alfred Jones being displayed
I would like to know how to apply this process in a real application I am struggling to link the data bases and display the results
I have tried lookups but must be missing something
after I have mastered this I will eventually want to encrypt the set source and set data
anybody help would be most appriciated asap as this has stopped me from getting my first major project underway
They also need to pass only the index id on to to the nested table which shall be used to then collate in sets etc so that no sorce content is held in the set only a number which through a nested trail points back to the original table
this would have the benefit of less duplication, faster processing and better security
ie
Standard Table (ST1) has Male_Forename_ID and Male_Forename fields
00001 Alfred
00002 Fred
00003 John
Standard Table (ST2) has Female_Forename_ID and Female_Forename fields
00001 Amy
00002 Frances
00003 Joanne
Standard Table (ST2) has Surname ID and Surname fields
00001 Smith
00002 Jones
DataBase Tables used in Application would be:-
MFID FFID SID
Male_Forename_ID, Female_Forename_ID and Surname_ID
00001 00001 00001
00002 00002 00002
00003 00003
the resultant Database Sub-set created for - Lets Say - a Client would be composed of the either one or more Male_Forename_ID's or Female_Forename_ID's added to a Surname_ID this would then, through pointers be identied back to the source files and would only then when require upon a call uperation display the result held by the source files which would be relevant to the combined SET_ID's
ie
Taken from FFID & SID
an ID = 00001+00001
Client_ID = 0000100001
would result in the name Amy Smith being displayed
whereas:-
Taken from MFID & SID
an ID = 00003+00001+00002
Client_ID = 000030000100002
would result in the name John Alfred Jones being displayed
I would like to know how to apply this process in a real application I am struggling to link the data bases and display the results
I have tried lookups but must be missing something
after I have mastered this I will eventually want to encrypt the set source and set data
anybody help would be most appriciated asap as this has stopped me from getting my first major project underway
Comment