A
Andrew Wayne
In a data base design i have several fields in a table
including "ID"(AutoNumber) "LastName"(Text) and "Envelope
Number"(Number)
The indexes are LastName (ascending)(allow duplicates)
and Emvelope Number(ascending) (No duplicates allowed)
I have a combo box to Lookup the LastName, however the
records are not in alpha order. It seems to conflict by
having the index on Envelope Number. I understand I
could use the combo box and base it on a query, but when
I start the Combo Box Wizard, it does not give me the
choice to base the Combo on a query.
Thanks for any help
including "ID"(AutoNumber) "LastName"(Text) and "Envelope
Number"(Number)
The indexes are LastName (ascending)(allow duplicates)
and Emvelope Number(ascending) (No duplicates allowed)
I have a combo box to Lookup the LastName, however the
records are not in alpha order. It seems to conflict by
having the index on Envelope Number. I understand I
could use the combo box and base it on a query, but when
I start the Combo Box Wizard, it does not give me the
choice to base the Combo on a query.
Thanks for any help