0001893: Ability to select unique items from lookup, but reset this for each master item

ID	Project	Category	View Status	Date Submitted	Last Update

0001893	Advanced Data Generator	General	public	2021-06-29 09:59	2023-01-18 14:50

Reporter	Martijn Tonies	Assigned To	Martijn Tonies
Priority	normal	Severity	feature	Reproducibility	have not tried
Status	closed	Resolution	fixed
Fixed in Version	4.1.0

Summary	0001893: Ability to select unique items from lookup, but reset this for each master item
Description	Ability to select unique items from lookup, but reset this for each master item
Additional Information	Suppose I have Table 1 and a "child" Table 2 on FK-PK relationship. I want to create between 1-5 rows in Table 2 for every row in Table 1. I want a data field that I want to select at random from Table 3 (so e.g. Table 1 is Orders, Table 2 is Order Lines, and Table 3 is Products). I see that we can randomly select this product ID via random or unique. So I'm generating n rows in Table 2 for every row in Table 1. I want Table 2 to pick random values from Table 3. I am using unique, because, I don't want the same product to appear twice in the same order. But I cannot use unique, because it assumes that each product will be selected only once for the ENTIRE order lines table. However, I only want it to be unique for the set of 1-5 records that I'm creating per Order table line. Does this make sense? Is there a way to do that?
Tags	No tags attached.

DBMS & Version

Date Modified	Username	Field	Change
2021-06-29 09:59	Martijn Tonies	New Issue
2022-11-14 13:47	Martijn Tonies	Assigned To	=> Martijn Tonies
2022-11-14 13:47	Martijn Tonies	Status	new => assigned
2022-11-16 12:54	Martijn Tonies	Status	assigned => resolved
2022-11-16 12:54	Martijn Tonies	Resolution	open => fixed
2022-11-16 12:54	Martijn Tonies	Fixed in Version	=> 4.1.0
2023-01-18 14:50	Martijn Tonies	Status	resolved => closed