I have a table, say called Colours, which contains some fixed records. Primary Key being Colour Name (Red, Yellow, Green, etc...) with various related fields (maybe Hue, Brightness, Contrast, etc...)
I have another table setup, say called Universe, which contains a field called Planets (Saturn, Pluto, Neptune) and various related fields (maybe size, density, distance, etc...)
I have another table setup, say called Results, which contains a compound key (of two keys). One links to the field Colour Name (in table Colours) and the other linking to the field Planets (in table Universe) with other various fields. I want to create a record for each colour in this new table against each Project Name ie.
Planets Colour Name Field 2 Field 3
Saturn Red XXX XXX
Saturn Yellow XXX XXX
Saturn Green XXX XXX
Pluto Red XXX XXX
Pluto Yellow XXX XXX
Pluto Green XXX XXX
The current way I have been doing it is to simply create new records manually, which for the data I am really using is a nightmare because the "Colours" table contains 96 records so for every record in the "Universe" table requires 96 records against them in the table Results.
Is there a way to get this process automated so that whenever anyone enters a new Planet record then new records (96 of them) are created in the Results table? Or maybe a button can be pressed to automate this creation?
I am sorry if I have not explained this very well!!!