I'm having a problem with duplicate entries in the parent drop down list. I'm modifying the Inventory Tracking site application that came with SP. I have three lists (field names in parentheses are the Static names):
Title (Title) - text column of types of items, i.e., Mailing Supplies
Title (Title) - text column of name of individual item, ie., Envelope
Category (AssetType) - Lookup to Title in Categories list
CategoryLookup (CategoryLookup) - text field set equal to Category
Item (ITItem) - lookup to Title in Inventory
Category (Category) - lookup to CategoryLookup in Inventory. SP would not let me create a field that is a lookup to another lookup field.
Here is the code I have:
The Transactions list is where all the "sales" are recorded. What I would like is for the user to select a category to filter the items drop-down. I've tried various permutations of the above but no matter what I do, on the New Sale form,
Category always has duplicate entries. Regardless of which entry I choose, the correct items and the correct number of items show up in the Item drop-down. I'm sure I'm missing something obvious - at least to those who know what they are doing!