Hello - I am having trouble with a script to pair each record from Table 1 with each record from Table 2 to populate Table 3.
For example purposes lets say I have a Table 1 with flower names and a Table 2 with flower colors. What I want is to run a script that will pair each flower with each color and populate Table 3 as shown below.
Any help would be greatly appreciated!!!
|Flower ID||Flower Name|
|Flower ID||Flower Color|
|Pair ID||Flower Name||Flower Color|