Hello, in my database I have a form which shows how many years of experience a person has per item.
In the form is a subform with columns a, b and c, all three combo-boxes. Depending from the topic selected in the first column (a), the second colomn (b) shows only the related groups (in stead of all groups). And depending from the selected group, the third colomn (c) shows only the related items of that group. This works in my subform, but only for one row. This is wrong, cause a person can have experience on multiple items.
Is it possible to show (and choose) all items (with years) from 1 person in a subform. I can write down the code if necessary. Thanx.
In the form is a subform with columns a, b and c, all three combo-boxes. Depending from the topic selected in the first column (a), the second colomn (b) shows only the related groups (in stead of all groups). And depending from the selected group, the third colomn (c) shows only the related items of that group. This works in my subform, but only for one row. This is wrong, cause a person can have experience on multiple items.
Is it possible to show (and choose) all items (with years) from 1 person in a subform. I can write down the code if necessary. Thanx.
