Developing form for many-to-many
I am still finding my way around Filemaker and need to set up a form with details from two tables A and B in which the link table (lets call it AB) is automatically updated when adding a cross reference to either A or B. Setting up the tables and their relationships was straightforward, but how do I implement this at the form level? More specifically, how can I set up the form so it will allow me to use a lookup linked to say table B and search for a value in that table and then automatically enter the corresponding B_ID as well as the A_ID into the linking AB table? Any pointers would be much appreciated.