Hi!I'm trying to design a database where products are made up of a number of different units. Let's say there are a maximum of 10 types of units, but the quantity differes from each product.For example:The product Box1 consists of 64 units of part X ...
Hi!I have the tables "units" "location," and "event."Events have a lookup field to location, and a location has multiple units. What I want to acheive is to create an automation so that when a record is created in event, a new event for evry unit in ...
The form will not work, as the input is received from an external application.If it is not possible to create a service record for each unit as an automation, I will need to make some kind of lookup for last serviced to track it.
