Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Primary

Posted on 2015-01-07
1
Medium Priority
?
123 Views
Last Modified: 2015-02-13
Here is the problem that I see....
When I fill out the dependents name it should add the primary as a member with $125.00 monthly charge, it dose not...

Primary
0
Comment
Question by:noad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 25

Accepted Solution

by:
Will Loving earned 2000 total points
ID: 40539100
OK. Take a look at the uploaded example:

1. All fields related to the Individual name and contact info have been moved to Dependents. There's no need to duplicate the fields in both tables.

2. A new relationship has been added called "Primary Insured" that links the Insured record to the Primary record in dependents. Take a look at the relationship which has two predicates: zk_InsuredID and zk_Constant (which is a 1) to Dependents::PrimaryInsured which is also a 1 when it is checked.

3. The name and address fields on the Insured record now are from the Dependents table using the PrimaryInsured relationship. When you create a new Insured record you can fill in the name address fields and it will immediately create a new Dependent record marked as Primary.
Insured-v3.fmp12
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

721 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