There are three ways of approaching this.

1.) Filter with dropdown's

2.) Filter main criteria with dropdown (winner or nominee) then search award winner column

3.) Open search of all winners

Need ability to choose one row and populate information into a a few text fields.

Some text fields should be read only, others can be edited up to "X" number of characters

Info is pushed over into a text field for the product.

arrow&v
Award Status
Award Type
Book
Author First Name
Author Last Name
Reference
Winner
American
Jubilee
Toni
Tipton-Martin
JBF_001
Winner
Baking and Desserts
Living Bread
Daniel
Leader
JBF_002
Winner
Baking and Desserts
Living Bread
Lauren
Chattman
JBF_003
Winner
Beverage with Recipes
The NoMad Cocktail Book
Leo
Robitschek
JBF_004
Winner
Beverage without Recipes
The World Atlas of Wine 8th Edition
Hugh
Johnson
JBF_005
Winner
Beverage without Recipes
The World Atlas of Wine 8th Edition
Jancis
Robinson
JBF_006
Winner
General
Where Cooking Begins
Carla
Lalli Music
JBF_007
Winner
Health and Special Diets
Gluten-Free Baking At Home
Jeffrey
Larsen
JBF_008
Winner
International
Ethiopia
Yohanis
Gebreyesus
JBF_009
Winner
International
Ethiopia
Jeff
Koehler
JBF_010
Winner
Photgraphy
American Sfoglino
Eric
Wolfinger
JBF_011
Winner
Reference, History, and Scholarship
The Whole Okra
Chris
Smith
JBF_012
Winner
Restaurant and Professional
The Whole Fish Cookbook
Josh
Niland
JBF_013
Winner
Single Subject
Pasta Grannies
Vicky
Bennison
JBF_014
Winner
Vegetable-Focused Cooking
Whole Food Cooking Every Day
Amy
Chaplin
JBF_015
Nominee
American
South
Sean
Brock
JBF_016
Nominee
American
Cook Like a Local
Chris
Shepherd
JBF_017
Nominee
American
Cook Like a Local
Kaitlyn
Goalen
JBF_018
Nominee
Baking and Desserts
Pastry Love
Joanne
Chang
JBF_019
Nominee
Baking and Desserts
Dappled
Nicole
Rucker
JBF_020
Nominee
Beverage with Recipes
The Martini Cocktail
Robert
Simonson
JBF_021
Nominee
Beverage with Recipes
Last Call
Brad Thomas
Parsons
JBF_022
Nominee
Beverage without Recipes
The Complete Guide to Japanese Drinks
Stephen
Lyman
JBF_023
Nominee
Beverage without Recipes
The Complete Guide to Japanese Drinks
Chris
Bunting
JBF_024