Adding new records to a subform

[Meagan]

I have not been able to find anything quite like this on the web so I am
asking for suggestions. To some of you experts this may be very simple (I
hope!).
Students will be entered into an Access database along with typical
information (address, etc). They will also have an advisor assigned to them
(a faculty member) and then as time goes on, they will select their graduate
committee (i.e. more faculty members). I have a subform that has combo boxes
so they can either pick the faculty name from a list of already entered
faculty names (as this list will be built as new students are entered) or
they can click on a button to bring up a new subform to enter a faculty
member not yet on the preexisting list. I have 2 main problems. 1. I do not
know how to link the FacultyAdd names to the already existing Faculty data
so that in the future these new names will also appear in the combo boxes.
2. How do I allow several faculty members to be entered for each student? If
I want up to 5 faculty members (including the advisor) must I have 5 ADD
buttons? Any insight would be greatly appreciated.

 

[Jackie L]

Meagan,
I am going to address point number 2 first. You must set up an additional
table to be able to enter multiple faculty for one student. It is not good
programming/planning to not use a one to many relationship here.
For your adding to the drop down list, take your existing faculty table and
create your drop downs off that. To add a faculty member who does not exist
in the faculty table, make a button to open a new form to add new faculty
member, on the On Close event of that form you will need to requery your drop
down box so that the new member shows up in the drop down.

I hope this helps. Please let me know if this does not make any sense.
Jackie )