Combobox subform multiple records

[The_Vicar75]

Hi,

Here's my prob:
I've got a table with a unique Key (= serial nr)
These parts are in a project (= second column in table)

Now I would like to make a form (maybe with subform) where I can select a project in a combo and that all the parts (serials) within that project are shown.

Every serial has several data in it's record that has to be shown.

Hope my question is clearly written down to understand (see attach for example).

thx,
Vicar75.

 

[John Big Booty]

I think you are looking for a Cascading Combo Box set. Try also searching this forum for discussion on the subject.

 

[The_Vicar75]

Yep, found what I was looking for there... cascading combo.

tx!

Vic.