I have two separate data tables that a sql query needs to pull data out of$.$

The first table is called Collection$\_$Details and contains a Text$\_$Entry column and a Collection$\_$ID column. The text entry column contains the names of completed text entry forms and the Collection$\_$ID column contains unique ID numbers generated each time a text entry form has data entered into it$.$

The second table is called Sample$\_$Details and contains a Collection$\_$ID$,$ Text$\_$Entry, Value and Performed$\_$Date columns. The Collection$\_$ID column contains the unique IDs generated from the Collection$\_$Details table. The Text$\_$Entry column contains units of the type of entry that was being recorded and the Value column contains what was inputted for that entry. The Performed$\_$Date Column marks when the entry form was completed.

The sql query needs to have a search field for the Text$\_$Entry column from the Collection$\_$Details table. The Text$\_$Entry names that will be searched for are $($Gummy$\_$Worm, Gummy$\_$Bear, Taffy$).$ Based on the name searched for in the Text$\_$Entry column, the query needs to pull out each associated ID number generated from the Collection$\_$ID column. It then needs to take those Collection$\_$ID numbers and search for them in the Sample$\_$Details table Returning the values from the Text$\_$Entry, Value and Performed$\_$Date Columns. Data returned should be ordered by most recent performed date to least recent.

Thank you for the help