Many-to-one form subform

[LordGarf]

Hi all,

I have a problem.
I have 2 tables.
One table called person and one table called department
(school example to explain the problem)

persan has a bunch of fields including a departmentID

department has a bunch of fields like name, street, number etc...

one person belongs to one department. one departmant can have many persons.

i have a form where you can add a person.
On this form I have a subform wich is connected to department.
and In the wizard I said that the departmentID of the main form(person) is the filter for the subform.
But now I would like it to be so that when i change the department in the subform or create a new one that the person record is updated to.

so the whole subforms acts like some kind of combo box where you select a department. The advantage of this is that you can see the department fields on the person form and that you can create a new one when inserting a person.

can anybody help me with this?

thanks in advance.

tank you,

best regards,
Lord_Garfield

 

[Hmadyson]

Instead of using a subform for the department, why don't you use a dropdown or listbox. This way you can assign the listbox or dropdown to a bound column on your table which is departmentid, and you can show the description in the dropdown.

Please let me know if I can provide more assistance.