zoglchaim770
Programmer
- Jun 19, 2003
- 15
I have 2 joined tables
Parent table is [parents]
Child table [children]
I need to create a table, query or form, with fields [parent last name] and [child first name]
Both of the fields should be displayed as a combo box, and most importantly, that ones I choose a record in [parent last name] it should filter the records in [child first name] and show only, and be able to choose from records related to the recored in parent table that I just selected
exsample
parent 1 has 2 kids: kid 1.1, kid 1.2
parent 2 has 2 kids: kid 2.1, kid 2.2
when i will seleced parent 2 from the [parent last name] combo box, i will see in the second combo box [child first name] only kid 2.1 and kid 2.2
i hope you undestend my question
Parent table is [parents]
Child table [children]
I need to create a table, query or form, with fields [parent last name] and [child first name]
Both of the fields should be displayed as a combo box, and most importantly, that ones I choose a record in [parent last name] it should filter the records in [child first name] and show only, and be able to choose from records related to the recored in parent table that I just selected
exsample
parent 1 has 2 kids: kid 1.1, kid 1.2
parent 2 has 2 kids: kid 2.1, kid 2.2
when i will seleced parent 2 from the [parent last name] combo box, i will see in the second combo box [child first name] only kid 2.1 and kid 2.2
i hope you undestend my question
