Hello. I have set up my database definition as follows:
ID => [0, 'alpha', 10 , 10, 1, '', '' ],
dept => [1, 'alpha', 50 , 50, 1, '', '' ],
dept_desc => [2, 'alpha', '50x4', 150, 1, '', '' ],
practice => [3, 'alpha', 30 , 150, 1, '', '' ],
practice_desc => [4, 'alpha', '50x4', 150, 1, '', '' ],
first_name => [5, 'alpha', 20 , 50, 1, '', '' ],
middle => [6, 'alpha', 20 , 50, 0, '', '' ],
last_name => [7, 'alpha', 20 , 50, 1, '', '' ],
degree => [8, 'alpha', 50 , 150, 0, '', '' ],
title => [9, 'alpha', 50 , 150, 0, '', '' ],
type_of_practice => [10, 'alpha', 50 , 100, 1, '', '' ],
clinical_interests => [11, 'alpha', '50x4', 150, 1, '', '' ],
medical_school => [11, 'alpha', 50 , 150, 0, '', '' ],
residency => [12, 'alpha', '50x5', 250, 0, '', '' ],
fellowship => [13, 'alpha', 50 , 150, 0, '', '' ],
board_certification => [14, 'alpha', 50 , 150, 0, '', '' ],
other_training => [15, 'alpha', 50 , 150, 0, '', '' ],
graduate_school => [16, 'alpha', 50 , 150, 0, '', '' ],
clinical_training => [17, 'alpha', 50 , 150, 0, '', '' ],
certification => [18, 'alpha', 50 , 150, 0, '', '' ],
professional_assoc => [19, 'alpha', '50x3', 200, 0, '', '' ],
languages => [20, 'alpha', 50 , 150, 0, '', '' ],
practice_office => [21, 'alpha', 50 , 100, 1, '', '' ],
practice_location => [22, 'alpha', '50x2', 150, 1, '', '' ],
practice_phone => [23, 'numer', 14 , 14, 1, '(757) ', '' ],
practice_fax => [24, 'numer', 14 , 14, 0, '(757) ', '' ],
email => [25, 'alpha', 50 , 50, 0, '@evms.edu', '.+\@.+\..+' ],
academic_office => [26, 'alpha', 50 , 100, 0, '', '' ],
academic_location => [27, 'alpha', '50x2', 150, 0, '', '' ],
academic_phone => [28, 'numer', 14 , 50, 0, '(757) ', '' ],
after_hours_phone => [29, 'numer', 14 , 50, 1, '(757) ', '' ],
photo => [30, 'alpha', 50 , 90, 0, 'http://www.evms.edu/services/doctors/photos', '' ],
authorized_user => [31, 'alpha', 20 , 50, 1, '', '' ]
);
I want to be able to pre-enter the dept and practice descriptions so they will be
associated with the corresponding dept and practice, and will not appear on the add
record screen (I know I will need to make my own forms later). I want the author users to
be able to select a dept from a dropdown menu and then select one or more practices from a
list of checkboxes, and have the associated descriptions appear in the output of the
search. Can someone help me figure this out? Thanks.
Kim Lewandowski
[This message has been edited by kiml (edited August 09, 1999).]
Code:
%db_def = ( ID => [0, 'alpha', 10 , 10, 1, '', '' ],
dept => [1, 'alpha', 50 , 50, 1, '', '' ],
dept_desc => [2, 'alpha', '50x4', 150, 1, '', '' ],
practice => [3, 'alpha', 30 , 150, 1, '', '' ],
practice_desc => [4, 'alpha', '50x4', 150, 1, '', '' ],
first_name => [5, 'alpha', 20 , 50, 1, '', '' ],
middle => [6, 'alpha', 20 , 50, 0, '', '' ],
last_name => [7, 'alpha', 20 , 50, 1, '', '' ],
degree => [8, 'alpha', 50 , 150, 0, '', '' ],
title => [9, 'alpha', 50 , 150, 0, '', '' ],
type_of_practice => [10, 'alpha', 50 , 100, 1, '', '' ],
clinical_interests => [11, 'alpha', '50x4', 150, 1, '', '' ],
medical_school => [11, 'alpha', 50 , 150, 0, '', '' ],
residency => [12, 'alpha', '50x5', 250, 0, '', '' ],
fellowship => [13, 'alpha', 50 , 150, 0, '', '' ],
board_certification => [14, 'alpha', 50 , 150, 0, '', '' ],
other_training => [15, 'alpha', 50 , 150, 0, '', '' ],
graduate_school => [16, 'alpha', 50 , 150, 0, '', '' ],
clinical_training => [17, 'alpha', 50 , 150, 0, '', '' ],
certification => [18, 'alpha', 50 , 150, 0, '', '' ],
professional_assoc => [19, 'alpha', '50x3', 200, 0, '', '' ],
languages => [20, 'alpha', 50 , 150, 0, '', '' ],
practice_office => [21, 'alpha', 50 , 100, 1, '', '' ],
practice_location => [22, 'alpha', '50x2', 150, 1, '', '' ],
practice_phone => [23, 'numer', 14 , 14, 1, '(757) ', '' ],
practice_fax => [24, 'numer', 14 , 14, 0, '(757) ', '' ],
email => [25, 'alpha', 50 , 50, 0, '@evms.edu', '.+\@.+\..+' ],
academic_office => [26, 'alpha', 50 , 100, 0, '', '' ],
academic_location => [27, 'alpha', '50x2', 150, 0, '', '' ],
academic_phone => [28, 'numer', 14 , 50, 0, '(757) ', '' ],
after_hours_phone => [29, 'numer', 14 , 50, 1, '(757) ', '' ],
photo => [30, 'alpha', 50 , 90, 0, 'http://www.evms.edu/services/doctors/photos', '' ],
authorized_user => [31, 'alpha', 20 , 50, 1, '', '' ]
);
I want to be able to pre-enter the dept and practice descriptions so they will be
associated with the corresponding dept and practice, and will not appear on the add
record screen (I know I will need to make my own forms later). I want the author users to
be able to select a dept from a dropdown menu and then select one or more practices from a
list of checkboxes, and have the associated descriptions appear in the output of the
search. Can someone help me figure this out? Thanks.
Kim Lewandowski
[This message has been edited by kiml (edited August 09, 1999).]