I THINK I would like to retrieve some table data to a variable instead of a dataProvider like a list or grid. Can that be done?
Currently I have an authors table and a book table. I have an authorID field and a bookID field in the book table, and naturally just an authorID in the authors table. So I have a one to many relationship (one author has multiple books).
When I enter a book into the book table, I want an associated authorID from the authors table to go along. What is the best method for retrieving the authorID so that I can enter the associated authorID, bookID, bookTitle into the book table?
I was thinking that I could extract the authorID to a variable and then include that in my INSERT statement.