F
fairyfolk
I am a big-time newbie to Access, so please accept my apologies if thes
questions are really dumb. I have 2 problems that are similar to eac
other, but I can't figure out how so solve them. So I hope someone ca
help me.
_*Problem_1*:_Using_the_same_form_to_add_entries_into_a_field_in_a_linked_table
What I have: A field in one of my tables is linked to a list of value
in another table. I've created a form where when I am entering data,
can use a combo-box to choose one of the values from the other table.
What I need: I need to add the ability to create a new entry into th
list of values if it is not already on the list. For example, the mai
table contains information about a tutorial session with a field linke
to a list of tutors (e.g., TUTORIALSESSION.TutorName links t
TUTOR.TutorName). I would need to be able to add a new tutor to my lis
of tutors (TUTOR.TutorName) while entering data for each tutoria
session if that tutor is not already listed in my tutor table.
Problem 2 expands upon Problem 1.
_*Problem_2*:_Using_the_same_form_to_add_entries_into_multiple_fields_in_a_linked_table_if_a_key_value_is_new,_or,_if_the_key_value_already_exists,_getting__the_data_from_multiple_fields_related_to_that_value_and_automatically_entering_them_in_2_fields_in_the_form._
What I have: As in Problem 1, a field in one of my tables is linked t
a list of values in another table. I've created a form where when I a
entering data, I can use a combo-box to choose one of the values fro
the other table.
What I need: (1) In my form, if a value is new (i.e., not already i
the linked table and thus not in my drop-down combo-box), I need to ad
the ability to create a new entry into the list of values and ad
corresponding related information into the linked table. For example
the main table contains information about a tutorial session with
field linked to a list of students (e.g., TUTORIALSESSION.StudentI
links to STUDENT.StudentID). I would need to be able to add a ne
StudentID, FirstName and LastName to my list of students in my STUDEN
table while entering data for each tutorial session.
(2) If, however, the student is already in the student table, I woul
need to get the student's first and last name and have thes
automatically entered into associated fields in the form. At thi
point, the TUTORIALSESSION.StudentID link in the current record woul
need to be added, but not STUDENT.StudentID, STUDENT.FirstName o
STUDENT.LastName as these last 3 already exist in the database.
I hope that was clear. Any help or suggestions would be greatl
appreciated. Thanks
questions are really dumb. I have 2 problems that are similar to eac
other, but I can't figure out how so solve them. So I hope someone ca
help me.
_*Problem_1*:_Using_the_same_form_to_add_entries_into_a_field_in_a_linked_table
What I have: A field in one of my tables is linked to a list of value
in another table. I've created a form where when I am entering data,
can use a combo-box to choose one of the values from the other table.
What I need: I need to add the ability to create a new entry into th
list of values if it is not already on the list. For example, the mai
table contains information about a tutorial session with a field linke
to a list of tutors (e.g., TUTORIALSESSION.TutorName links t
TUTOR.TutorName). I would need to be able to add a new tutor to my lis
of tutors (TUTOR.TutorName) while entering data for each tutoria
session if that tutor is not already listed in my tutor table.
Problem 2 expands upon Problem 1.
_*Problem_2*:_Using_the_same_form_to_add_entries_into_multiple_fields_in_a_linked_table_if_a_key_value_is_new,_or,_if_the_key_value_already_exists,_getting__the_data_from_multiple_fields_related_to_that_value_and_automatically_entering_them_in_2_fields_in_the_form._
What I have: As in Problem 1, a field in one of my tables is linked t
a list of values in another table. I've created a form where when I a
entering data, I can use a combo-box to choose one of the values fro
the other table.
What I need: (1) In my form, if a value is new (i.e., not already i
the linked table and thus not in my drop-down combo-box), I need to ad
the ability to create a new entry into the list of values and ad
corresponding related information into the linked table. For example
the main table contains information about a tutorial session with
field linked to a list of students (e.g., TUTORIALSESSION.StudentI
links to STUDENT.StudentID). I would need to be able to add a ne
StudentID, FirstName and LastName to my list of students in my STUDEN
table while entering data for each tutorial session.
(2) If, however, the student is already in the student table, I woul
need to get the student's first and last name and have thes
automatically entered into associated fields in the form. At thi
point, the TUTORIALSESSION.StudentID link in the current record woul
need to be added, but not STUDENT.StudentID, STUDENT.FirstName o
STUDENT.LastName as these last 3 already exist in the database.
I hope that was clear. Any help or suggestions would be greatl
appreciated. Thanks
