Restricting values displayed in combobox

  • Thread starter Thread starter PK.10987
  • Start date Start date
P

PK.10987

I have two tables. Programme Info(prgCode, progName) and Subject
Info(progCode, subjCode, subjName). They have one to many relationship
through the programme code field.

When I select a programme category for eg. D1 I want only the subject codes
belonging to that programme category to be displayed in the form.

Now when i choose the combobox I have 10, 10, 20 as the subject codes. The
10 subject; one is for programme D1 and programme D2.

How do I resolve this problem?

Thanks,
PK
 
Look at the properties of the combo and check what columns are selected and
which ones are visible (ie look at the column width).
 
I didn't quite understand. The column width property is for increasing or
decreasing the width isn't it...
 
Sorry, I wasn't sure what you problem was (or is)?

If you want distinct values the use a query as the source of the combo and
insert 'distinct' after the 'select' and before the field names.
 
Back
Top