SharePoint Products TechCenter >
SharePoint Products and Technologies Forums
>
SharePoint - General Question and Answers and Discussion
>
Using Sharepoint to manage an inventory list
Using Sharepoint to manage an inventory list
- I have an excel workbook that I wish to rebuild to be fully serviceable within sharepoint.
I need to figure out how to accomplish two things to make this happen:
- I need to be able to search for inventory items based either on name, or serial number.
- I need to be able to update 14 additional fields associated with each inventory item.
So far, I've been able to make a little headway:
- Combining a 'Text Filter' and importing sections of the excel workbook sheets as 'lists'.
- I understand there is a way to change entries in lists
Problems:
- I cannot attach more than one 'Text Filter' to the list, so I cannot search two columns, limited to one.
- I need to return the 'found' item from the list as a column of data, not a row.
Any help on these matters would be really really appreciated.
Thank you so much,
-Aaron
All Replies
- Aaron,
You should be able to get multiple filters using a Data View Web Part and connected web parts. I don't understand your need to return a Column of data. Usually you would return Rows. Can you clarify?
M
Matthew McDermott, MVP MOSS
