Hi, I'm completely new to Dataverse, trying to build a data model to help with a Power Apps implementation. I need to build three tables:
Locations -> list of locations we're tracking inventory at. Primary key = Location ID
Items -> list of items we're tracking inventory for. PK = item ID
Inventory -> the inventory of a given item at a given location on a given day. PK should be a compound key of location_id, item_id, and inventory_date
I've built the first two tables (Locations and items) with no issues, but Dataverse seems to "force" me to define a single primary key column on the inventory table...which just doesn't work. The PK needs to be location_id + item_id + inventory_date. I'm struggling with this seemingly simple requirement...can someone point me towards some learning materials that may help?
Thanks!
Scott
