Hi All, Im creating an inventory management app with multiple locations. Would you set the location up within the product or create a seperate thing for each location with the products as a field?
It depends on how much information you want to store about each location.
If you just want to store the geographic address, you can just store a list of geographic addresses on each product.
If you want to store details about a location such as its name, description, employees, or any other related data in addition to its geographic address, then you should create a separate data type for locations.
In either case, you should have a list of locations on a product - in the first example your list will be a list of geographic addresses whereas in the second example your list will be a list of the data type “Location”
Thank you Sam, appreciate the feedback. It makes sense, Im just finding it challenging to add the products to the location. In the location data type i have created a field for list of products, and under Product date type I have created the field list of locations.