Sorry this is probably a really stupid question but I have just started using Filemaker having always used Access in the past and I am just starting to get to grips with it.

I have a database with two tables, Companies and Jobs.

Each table has a key field which is an auto number Companies ID and Jobs ID respectively.

The Jobs table also has a foreign key of Companies ID which is connected in a one to many relationship to the field of the same name in the Companies table.

What I would like to do is open the jobs form from the companies form so that it automatically creates a new record with the Companies ID field in the Job table populated by the relevant information from the Companies table.

I hope this makes sense.

John

Makes perfect sense.

There are at least 3 methods to create child records:

1. Allow creation of children directly in a portal by enabling "Allow creation" in the relationship.

2. Give the user a New Child button and use variables to populate the parent foreign key.

3. In a child record, give the user the ability to set the parent foreign key. If the list of possible parents is short, a popup menu is OK. Otherwise, use another method. For example, give them a popup window of parents in a list view, or filtered portal.

I've attached a demo that includes all three methods(although you should have either the New Job button or access to edit in the portal, but not both).

Topic_192215.zip

Thank you so much. This make total sense and is very helpful.