one form containing fields from many related tables

[lostgirl]

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.

[mr_vodka]

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.

[lostgirl]

Thanks John :

Regards,

Farah K.