Don't create a separate table for each work. That won't work. But with this relationship:
ParentTable::__pkParentID = ChildTable::_fkParentID
you can set up a portal to ChildTable on your ParentTable layout and be able to see/edit/create/delete child table records in the portal and you will only see those records that are linked to the current parent table record.
hmm..little bit hard to understand how to set up such relationship.
Im currently reading about relationships and portals. Would be great if you can explain how to set up this to see linked records on the other table layout.
__pkParentID should be defined to auto-enter a serial number
Open Manage | Database | Relationship.
Drag from ParentTable::__pkParentID to ChildTable::_fkParentID
Double click the relationship line this creates.
In the dialog this action opens, click the checkbox for "allow creation of records via this relationship" on the ChildTable side.
Click OK and use the portal tool to draw rectangle on your layout where you want a portal.
Select ChildTable in Show Related Records From, select the portal options that you want and click OK.
Then select the fields that you want to see in your portal from ChildTable.
Return to browse mode and you can now create new records in ChildTable by entering data in the blank bottom "Add" row. This is possible because you selected "allow creation..." for the child table in this relationship. WHen you enter data in the add row, FileMaker automatically copies the value of __pkParentID from the current record to the _fkParentID field in the the new ChildTable record.