K
Kirsten Palfreyman
Hello:
I am new to SQL and Access so be forewarned that I am probably asking a
stupid question. I would still most appreciate it if someone indulged my
ignorance and helped out a poor student. = )
Ok I am building a database in Access Projects with SQL server for a
class, in our business case we have members, instructors, and
associates. We created a supertype of person for or ERDs and normalized
relations and then two subtypes of that are Personnel and Members.
Personnel also has two subtypes of Instructor and Associate. I am
building data entry forms and I have a form with all the fields for
person (including an identity seed for Person_ID). I have been able to
create a macro that start running after someone enters information in
all the fields and then clicks the command button "Save Record". What I
would like the macro to do is look at the field "Person_Type" and based
on what is in there (either Personnel or Member) run the next correct
form. How would I set this up to do that? or can it even be done?
Also my macro has the following actions: Save, Open Form, GoToRecord
(create new), and SetValue (copies primary key value of Person to
Personnel_ID or Member_ID). However ti runs very slowly and sometimes it
wont open the form until I click on something else.
If anyone can help me with this I would definitely appreciate it.
Kirsten
I am new to SQL and Access so be forewarned that I am probably asking a
stupid question. I would still most appreciate it if someone indulged my
ignorance and helped out a poor student. = )
Ok I am building a database in Access Projects with SQL server for a
class, in our business case we have members, instructors, and
associates. We created a supertype of person for or ERDs and normalized
relations and then two subtypes of that are Personnel and Members.
Personnel also has two subtypes of Instructor and Associate. I am
building data entry forms and I have a form with all the fields for
person (including an identity seed for Person_ID). I have been able to
create a macro that start running after someone enters information in
all the fields and then clicks the command button "Save Record". What I
would like the macro to do is look at the field "Person_Type" and based
on what is in there (either Personnel or Member) run the next correct
form. How would I set this up to do that? or can it even be done?
Also my macro has the following actions: Save, Open Form, GoToRecord
(create new), and SetValue (copies primary key value of Person to
Personnel_ID or Member_ID). However ti runs very slowly and sometimes it
wont open the form until I click on something else.
If anyone can help me with this I would definitely appreciate it.
Kirsten