• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 965
  • Last Modified:

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

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
0
tempadmin
Asked:
tempadmin
1 Solution
 
Will LovingPresidentCommented:
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.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now