listbox - Displaying a multivalued list box/combo box in Access 2010 -
i have table containing information teachers university. 1 of fields multivalued list box containing choices types of students person teaches (pre doctoral/post doctoral/residents etc). trying display field on form, letting form wizard create controls form ends giving copies of same record each copy showing different selection students field (i.e. if select pre , post doctoral, record selector shows 2 records, both exact same information except 1 of student fields says pre doctoral , other says post doctoral).
i want show each option in list on 1 record. can't seem find kind of property can this. want able show possible options when adding new record. there options/code allow this?
my answer, may not like, not use multi-value listbox (or attachments field either). create hidden tables , relations cannot control and, want useful them, becomes problematic. cause issues exporting well.
i create, , maintain, own tables (a many-to-many relationship).
Comments
Post a Comment