We help IT Professionals succeed at work.
Get Started

FileMaker Pro 12 - problem creating new record in view with fields from two tables

tempadmin
tempadmin asked
on
1,029 Views
Last Modified: 2012-08-15
Newbie to FileMaker

I am working on an employee database using FileMaker Pro 12 and am having a problem with something.  I guessing it's something dumb, but I've spent too much time trying to correct it and am hoping to get some help here.

See attached screen shots for View, Relationships, etc.

What is happening
From the view when I select New Record to add a new employee, if I select a title from the drop down list populated from the Titles table, everything works as expected:  a new employee is added to the employees table and the Employees::titleIDfk field is populated correctly with the value from the Titles::titleIDpk field of that title.  
However, if I want to create a new employee with a new title and so I select Other from the drop down list and type for instance Crash Test Dummy, a new title IS NOT created in the Titles table and in the Employees::titleIDfk field, it shows Crash Test Dummy.

What I want to happen
From the view when I want to create a new employee with a new Title and so I select Other from the drop down list and type for instance Crash Test Dummy, a new title IS created in the Titles table and in the Employees::titleIDfk field, it shows the corresponding Titles::titleIDpk.
Filemaker-Sceeenshots---EE-post.pdf
Comment
Watch Question
President, Dedication Technologies, Inc.
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE