Trying to make new record in a different table/layout when opening
Ok, I got lost here...
I have two tables, with associated layouts in form mode. One is Customers, and the other Customers_details.
I've created an id field for each one, and the Customers id field is an autonumber one. In relationships, I liked both id fields and allowed the second one to be created and erased by the first one. Then, if I nest the second one as a portal in the first one, it will create child records and auto create the id number on it, so they are synced. Fine.
What I'm trying to do is the same thing, but without a portal. I want a button with a script that takes me to the the second layout, creates a new record and sync the id fields, just like it does in a portal. So next time I'm in the first layout, when I click that button, it takes me to the related record in the other layout.
I've tried a lot, but no success...Help! Any exemples?