Nov 09 2022 01:57 PM
We want to make an order list, but an order might have several suborders.
As an example, an order is inputted. Say 'Entertainment Set' which consist of a TV, Stereo and extra items.
Is it possible to create a sub list of the additional items to track? Say the total price is $1000 and only the stereo ships, can we make it as $200 Stereo shipped and received.
I have tried YouTube and Google with no luck.
Nov 09 2022 08:39 PM
@not_a_pro You can create hierarchy in SharePoint lists using lookup columns.
You can create a "Orders" list with common details for all suborders and 2nd "Suborders" list to store details of each suborder - in suborders list, you can create a lookup column from "Orders" list.
Documentation: Create list relationships by using lookup columns
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Nov 16 2022 08:33 AM
Nov 17 2022 12:41 AM
@not_a_pro You can create a simple canvas power apps to combine the list forms and submit the data in two separate lists.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.