We would like to create master-detail tables (relational datasets) where the Master contains customers and the Details table contains a variable number of orders. For example: a Customers dataset would contain customer data mapped to a Orders dataset containing a variable number of orders. An example schema would look like:
Customer_ID (serves as primary key)
Order_ID (serves as primary key)
Customer_ID (serves as foreign key)
Creating the Customer dataset is pretty straight forward but I’m not clear how to use Mockaroo to create variable numbers of mock Orders, e.g., Customer “123” ordered 5 items over 3 dates, while Customer “456” ordered 2 items on a single date, and so on.
The Mockoroo Foriegn Key tutorial on YouTube (https://www.youtube.com/watch?v=S_oYFGhZSkQ) seems to only support lookup values - not mocking up multiple/variable values tied to another dataset.
Any options/suggestions here?