Creating a new record in a join table
It does seem as if join table are a source of some trouble! I've looked through quite a few threads, but none seem to cover my problem completely.
I have two tables Towns and Agencies, with a small join table linking the two. The towns table is populated, as is the agencies table. On the Towns table layout, there is a portal that in theory shows agencies already in the town and that allows me to add new agencies to the list.
This means that I need it to add a new record in the join table automatically, containing the town key and the agency key. What do I need to do to get this to work?
I've tried a number of sample solutions (and looked at a demo or two) but I still end up with an empty join table!
I'll continue to read up about this, but if someone is able to point me in the right direction in the meantime, that'd be very helpful and most welcome!