Creating List from 2 Tables

[jim.weeda]

FileMaker Noob here.  I need to create a customer call list from a couple tables in my filemaker db.  I have my main customer information table which has all land owners and tenants in it.  The way our customer billing system is set up, a piece of property has a location number but can have two different accounts tied to it.  So, my table includes that location number, but can have 2 records under with that same number.  I have another table that I create records in from a .csv file that is exported from another system in the company.  It exports that location number.  I import that .csv into my database and link my two tables with that location number.   What i want to do is create a list that has the customer name and phone number based on the location numbers that i import.  I can't figure out after several hours of dinking around how to create that list.  

So, lets say i have a location number of 00015.  There is a land owner and a tenant listed under that location number in my main table.  When I import my .csv file, its only going to have 00015 listed one time.  I need my new list to pull both records so that when I export, I have everyones name/phone from that single location number I imported.

Thanks in advance!  

[mr_vodka]

What version are you on?

[jim.weeda]

12 Pro

[Lee Smith]

Please update your profile to reflect your version of FileMaker, Platform and OS. here is a quick link to do this MY PROFILE

[Lee Smith]

This topic has come up in the past, here is one search on Google that I just did, that has a few leads Here

 

Have you made an ERD (Entity Relationship Digram) for this, or are you winging it?

 

Here is a complex ERD for Rental Properties. HERE yours will not be this involved.

Edited August 23, 2013 by Lee Smith
edited text