Add existing records to table automatically
I have a populated table called 'Glossary' that I would like to bring into another table called 'Inspection Report' using View.
At the moment, it doesn't bring any of the entries into the View table unless I manually select each existing record. There are 24 records in the 'Glossary' table that I need to show, with Id's of 1 to 24.
Is there a way to have it do this automatically please?
Any help would be very much appreciated, Anna