⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

set_relation_n_n to insert if not found in relation table



peelman

peelman
  • profile picture
  • Member

Posted 01 July 2017 - 02:40 AM

When I get the drop down from set_relation_n_n it says No results match "blah" when there is no value found in the relational table.  Is there some way (using callbacks or something) where I can allow users to enter unknown values and then insert them into the xref table and the relational table without them having to do it via a separate form for each individual entry on another page?

 

For example if I enter "blah" I would enter blah and the new auto id into the right-side relational table, and then get that new id and enter the left-side id with the new "blah" id in the xref table, thus completing the relationship without leaving the text box in the UI.