var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Combo to display duplicate values in a form
I am working on a database for searching parts by typing or using the arrow down key, it seems to work fine for my purpose however it wont show duplicate values.
In my database I have itemno, Itemname, ItemShelf and ItemDescription fields.
I have ItemNo which is the part number setup as a combo box so person can search it by partnumber.
Itemshelf and Itemname are fields with duplicate values since parts are in various different location.
How can I make it work to where it will show me all of the locations instead of just one???
I have also tried in the main tbl called tblItems makind my index yes duplicates but that didnt help at all.
In the form try choosing part number 1253-0703 and you will notice that shelfname and shelf location is same for that part number, where it should have more shelf name and locations.
I am attaching my Dbase here