In the case of related tables, is there a way to add a record to the lookup table from the main table?
For instance, if I have a M:M songs and instruments
I'm inputting a song and need to add an instrument that isn't in the instruments database yet, can I add that without exiting the song, and adding a record and then updating/adding the song? The same for 1:M as well.
I know things like access have a quick add button. I didn't see this in the documentation if there is a way.
Thanks