带有嵌套条目的SharePoint Online列表

问题描述:

大家好,

我正在寻找将SharePoint用于跟踪项目的方法.我的团队跟踪维修情况,并希望使用清单进行操作.

I'm looking to use SharePoint for a tracking project. My team track repairs and would like to use a list to do this.

因此,该列表将包含一些条目,例如参考号,维修供应商,提出的日期等.其中之一将需要考虑每次维修所使用的材料.因此,例如,可能没有材料,或者可能有多达10个,每种材料 条目将包含部件号,价格,发票号等.

So, the list would have some entries such as Reference Number, Repair Vendor, Date Raised, etc. One of these would need to account for materials used for each repair. So for example, there could be no materials or there could be up to 10, and each materials entry would have a part number, price, invoice number, etc.

这可能与SharePoint列表有关吗,如果可以,最好的解决方法是什么?

Is this possible to do with a SharePoint list, and if so, what's the best way to go about it?

非常感谢

本.

你好,

这是一个典型的场景,您可以继续创建物料清单(带有零件编号,价格,发票编号等列).

创建另一个维修清单(带有参考号",维修供应商",日期增加"和 一个查阅列,它引用了启用了多重选择选项的材料列.)

This is a typical scenario where you can go ahead and create a Material List (with columns partnumber, price, invoice number, etc).

Create another Repair list (With columns like Reference Number, Repair Vendor, Date Raise and a Lookup column referring Material Column with multi select option enabled.)

这应该达到目的.