AnsweredAssumed Answered

A simple DB Setup question, I'm sure.  Please help

Question asked by bobrace on Dec 14, 2013
Latest reply on Dec 17, 2013 by bobrace

I am new to Filemaker Pro (using 12), have some DB experience and I am trying to setup a DB that is relational so that I may pull (or lookup) in formation in one table of DB into another table or DB.  I want one database or table that will hold last_name, first_name and social_security_number which we'll call NAMES.  In the other table, which will call ACCOUNT_INFO, it will hold account information about a customer such as account numbers, tranaction ammounts, etc. What I need is to set it up so that when a user is in ACCOUNT_INFO, the user will type a person's social security number and it will pull the person's name associated with that social into the account_info screen.  I have tried to this, using a "portal" field in the ACCOUNTS_INFO, but cannot get it to work.  This sounds simple to me, but I just cannot get it to work properly.  Any help would be very much appreciated.  Thank you.