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

Posted on 2012-08-13
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.
Question by:tempadmin
    1 Comment
    LVL 24

    Accepted Solution

    Well, I'm going to suggest you consider getting rid of your Title field. Here's why:

    Unlike some other databases, it's not always necessary in FM to create a separate table for a selection list such as titles. FM has a internal Value List function which I assume you are using to reference the Title table, but you also have some other options there. One is to use "Custom Values" specified directly in the Edit Value List dialog. This avoids the need to create a separate table and you can, on the layout, allow the user the option to Edit the list (Edit shows up at the end of the list if you select "Allow Editing of Value List" in Layout mode for that particular field).

    The other option is to select the Title field itself as the source for the drop-down list. What this does is display all unique entries already in the Title field. If the user goes to the field, gets the drop-down and then either hits backspace or clicks in the field, it becomes a regular Edit Box and you can enter a new value. Once that record is saved, the new Title value then appears in the drop-down list. This allows you to expand your list of entries but also keep tabs on whether you have similar entries already in the Title field itself.

    I do use a table for certain kinds of value lists where I want greater control. But for something like a Title, Honorific, Name Suffix or lots of other things, I will use one of FileMaker's built-in value list options rather than go to the trouble of creating a new table.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now