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

Filemaker Pro 12 Adding New Records to support table

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
rcowen00
Asked:
rcowen00
  • 3
  • 2
1 Solution
 
Will LovingPresidentCommented:
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
 
rcowen00Author Commented:
Here you go.  The specific form I am having issues with is ClientSiteDetail in the invoice portal.  Thanks!
Portables.fmp12
0
 
rcowen00Author Commented:
Any suggestions on this?  Thanks!
0
 
Will LovingPresidentCommented:
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
 
rcowen00Author Commented:
ahhhh...knew it was a simple error.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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