June 8, 200817 yr dear peepz, i have to warn you that although i am an experienced programmer and database designer, i am a total newbie when it comes to filemaker. so bear with me. i was wondering if it is possible for filemaker to automatically create a new record in another table when a new entry is made. for example:- table1: pk id_no, name, address, contact_no table2: fk id_no, field1, field2 so when i create a new record in table1, i want filemaker to automatically create a new record in table 2 for me. i have established the relationship between the each table in my database. for the convenience of my users, i have created a form where the subtable/child table is displayed in the tab control. however, i cannot insert any data in the tab control. do i need to write a script to enable this? if i do, can someone please forward me the script? regards, farah k.
June 8, 200817 yr If you have 'Allow Creation of Record' checked on the child side of the relationship, as soon as you enter in data into one of your child fields, it will create the related record for you.
Create an account or sign in to comment