Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Filemaker Pro 12 Adding New Records to support table

Posted on 2014-02-14
5
Medium Priority
?
632 Views
Last Modified: 2014-02-21
I have a form that includes a portal where the user enters new invoices.  Within the invoice portal I have 2 popup menus for renewal type and technician.  When I add a new invoice a new record is added to both the Renewal Type and Technician table even though I'm selecting an existing Tech and Renewal Type.  I have tried researching and playing with the relationship type to no avail.  Thanks!
0
Comment
Question by:rcowen00
[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
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:Will Loving
ID: 39860025
It sounds like your relationship structure is setup such then when you enter a value in the Renewal Type and Technician fields, that a new record is being generated because there is not existing match. In order to diagnose this properly I'll need to see the relationship graph including the Edit Relationship dialog between each pair of tables. The easiest way to do that is for you to upload a example file with some data in it (fake data) so that I can see what's happening. Screen shots are ok but an actual file is much faster to diagnose.
0
 

Author Comment

by:rcowen00
ID: 39860190
Here you go.  The specific form I am having issues with is ClientSiteDetail in the invoice portal.  Thanks!
Portables.fmp12
0
 

Author Comment

by:rcowen00
ID: 39863121
Any suggestions on this?  Thanks!
0
 
LVL 25

Accepted Solution

by:
Will Loving earned 2000 total points
ID: 39865957
It's very simple. In your Invoice Portal you have the wrong fields on the layout. The fields for Tech and Renewal Type should be the TechID and RenewalTypeID fields in the Invoice Table, NOT the fields in the Renewal Type or Technicians table. Those table are primarily there to populate the drop-down menus.

The way it's currently setup, if you select a value from the popup menu, you're directly entering that value into the corresponding table (RenewalType or Technicians) which forces a new record to be created in that table via the relationship.

By the way, you'll may want to add a ClientID field on Invoices (and possibly LineItems/Pricing) as well and use Auto-Enter to populate it from the ClientSite table. Depending on what you're doing it can help with things like reporting.

Portables.fmp12
0
 

Author Comment

by:rcowen00
ID: 39877667
ahhhh...knew it was a simple error.  Thanks!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

618 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