My database consists of 2 tables: Stories and Themes.
Stories keeps track of various elements of literary stories (Title, Genre, number of pages, etc.). Key field is WorkID. Each story has one record. Sometimes more than one record can have the same title. I know which is which by the Genre field.
Themes is simply a table of themes that are yes/no fields. Any story can have any number themes. I tried relating this table via WorkID, which is a lookup field in the Themes table.
Each table has a form built from it.
On the Story form, there is a button called Themes.
If a record exists in the Theme with a corresponding WorkID, all is well: I can see the related record.
Problem is, I'm still in the data entry mode. Most of the records in the Story table don't have Theme records associated with them.
Is it possible to arrange things so that if a Story doesn't yet have a Theme record associated with it, clicking on the Themes button will create a new record for that story? Currently when I click on that button for such a story, a blank record is created, but the WorkID field isn't filled in. (It would also be great if I could have the Title and Genre appear).
Sorry if the wording of my question seems confused: I'm kind of new to this. And thanks in advance for any help that can be offered.
Izzo248