Please excuse my ignorance as I am very new to Zoho and while for the most part the user interface is very intuitive, the deeper possibilities with coding remain a bit obscure to me as my knowledge in that field is quite limited.

Essentially what I am trying to do is create a database for storing information about lectures. This database is very simple and I have designed it using only two forms: talk and excerpt. Whereas a talk can exist without any excerpts, every excerpt is part of a talk and only one specific talk.

The way I have it now is that talk has certain fields such as a title, location, date, description, and so on. Excerpt has certain fields, one of which is timestamp (any way to get a time without a date, by the way?), another is quote, rating, etc.

The relationship between the two is that I have added 'excerpt' as a subform in talk, so that whoever is inputting the information about the talk can add as many excerpts as they like. This flow makes the most sense to me, that in order to add an excerpt we're not using a 'lookup' to add it independently from the talk, but rather they have to be added in the original talk or edited in. 

So far so good. When I look at the talk report, everything is great. However, when I look at the excerpt report, which is another important way to sort and access this database, the excerpts don't contain any information about the talk they belong to.

So my question is how to achieve this. If you add an excerpt inside a talk, it doesn't really make much sense to have a lookup field to relate back to the talk that you are in the process of creating. 

Is there a simple and obvious solution here that I'm not aware of? Would love some help.

Thanks and all the best,

Siddhartha