I have two seperate data tables I need a sql query 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 Collected$\_$ID$,$ Text$\_$Entry, Value and Performed$\_$Date columns. The Collected$\_$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$\_$DateColumn 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 numbergenerated from the Collection$\_$ID column. It then needs to take the Collection$\_$ID numbersand 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.