In Table A, I am trying to create three columns whereby each column would automatically and randomly select a person listed in Table B (same column), whenever a new record is created in Table A.
However, these are the additional requirements:
- There cannot be any repeats within a particular row.
- Repeats within a column (i.e., on several rows) is OK but is conditionally limited to a maximum number of two repeats.
- Selections are conditional based upon the person’s status (in Table B) (e.g., “status 1”).
Here’s an example.
TABLE B (the list of persons that would be randomly selected from in Table A)
TABLE A (what would be a correct random selection given the parameters)
Table A meets the requirements, because it:
- Selections are “randomly” made.
- There are NO repeats on each row.
- A maximum of TWO repeats are permitted per column.
- Only the people who have “status 1” from Table B.
