nathan2314
12-16-2008, 08:03 AM
Hey Good morning everyone, :hi::hi:
I need some advice on the best way to add supporting documents and hyperlinks to my database. Here is the way things are set up as of now.
I have a Main table with unique individuals with primary key = Person_ID. So this main table is now linked to several other subtables by person_ID. Some of these subtables are things like PersonAffiliations, SpouseAffiliations, FinancialInformation, PastHistory, OverseasExperience, TraitsNAbilities, FamilyMembers etc ... each with a primary key of its own and a foreign key of Person_ID. So now I also have a supporting materials table that has its own primary key (SupportingMaterials_ID) but has foreign keys for the main table AND all the subtables (ie person_ID, PersonAffiliations_ID, SpouseAffililiations_ID, FinancialInformation_ID, PastHistory_ID etc....). The SupportingMaterials table has two fields that hold the supporting materials. One is a OLE data type where the user can upload anykind of document, bmp, pdf, jpeg etc... and the second is a hyperlink field where the user can input a hyperlink.
Ok so now I'm kinda stuck on how to implement this set up on my current forms. I have a main form with the information on the MAIN Table at the top with the lower part of the form with a 'tab' control that has all the subtables (PersonAffiliations, SpouseAffiliations,FinancialInformation, PastHistory etc..) as subforms.
So the question is how do I have the options of allowing the user to upload supporting materials (documents, hyperlinks...) for each of the subforms/mainform?? I abit unclear since for each subform I would have to link the Primarykey in the subform to the foreign key in the supportingmaterials table for each subform/table I guess and have a button to click that would allow the user to upload? But what about the case when one document could be a supporting material for more than one subtable (ie overseasExperience and financial information etc...) Not sure of what the best approach here would be.
Appreciate any advice!! :)
I need some advice on the best way to add supporting documents and hyperlinks to my database. Here is the way things are set up as of now.
I have a Main table with unique individuals with primary key = Person_ID. So this main table is now linked to several other subtables by person_ID. Some of these subtables are things like PersonAffiliations, SpouseAffiliations, FinancialInformation, PastHistory, OverseasExperience, TraitsNAbilities, FamilyMembers etc ... each with a primary key of its own and a foreign key of Person_ID. So now I also have a supporting materials table that has its own primary key (SupportingMaterials_ID) but has foreign keys for the main table AND all the subtables (ie person_ID, PersonAffiliations_ID, SpouseAffililiations_ID, FinancialInformation_ID, PastHistory_ID etc....). The SupportingMaterials table has two fields that hold the supporting materials. One is a OLE data type where the user can upload anykind of document, bmp, pdf, jpeg etc... and the second is a hyperlink field where the user can input a hyperlink.
Ok so now I'm kinda stuck on how to implement this set up on my current forms. I have a main form with the information on the MAIN Table at the top with the lower part of the form with a 'tab' control that has all the subtables (PersonAffiliations, SpouseAffiliations,FinancialInformation, PastHistory etc..) as subforms.
So the question is how do I have the options of allowing the user to upload supporting materials (documents, hyperlinks...) for each of the subforms/mainform?? I abit unclear since for each subform I would have to link the Primarykey in the subform to the foreign key in the supportingmaterials table for each subform/table I guess and have a button to click that would allow the user to upload? But what about the case when one document could be a supporting material for more than one subtable (ie overseasExperience and financial information etc...) Not sure of what the best approach here would be.
Appreciate any advice!! :)