Creating Changes to an existing database.

  • Thread starter Thread starter Suzanne Wyatt
  • Start date Start date
S

Suzanne Wyatt

Ok. I have an existing database, that was created by someone else and my
boss wants some changes made. Currently it has 5 tables, tblSurvey,
tblPrograms, tblUser, tblIncidents, and tblInfoSheets,

Regarding the Survey Table, it is related to the Program Table and hence my
dilemma, my boss now wants programs sub categorized, IE Residential,
OutPatient, and Intensive Outpatient as Services related to Programs Group
Therapy/Outpatient, Glass House/Residential etc.

How can I add a new table, Services with these Categories, and assign the
Programs according to which catagory they belong to without losing any of
the data.

Would it be better to start over and import the data in queries or just make
certain changes to the existing database?
 
Sounds like you need to add tblCategory, and add CategoryID to tblPrograms.
Populate each record in tblPrograms with the correct CategoryID, and then
set a relationship between tblCategory and tblPrograms.
 
Thanks for the Info, second part of question the reports are retrieved from
a form with an unbound listbox with the name of the program, should I change
the form to reflect the catagory as a combo box? and if so how would I
configure the list box to populate with the related catagory. TIA Suzanne
 
Back
Top