AnsweredAssumed Answered

How to add a join table to an existing file

Question asked by pgrehan on Oct 8, 2012
Latest reply on Nov 5, 2012 by comment

I am new to Filemaker and having been learning by doing. The only problem with this approach is that I sometimes recognize my mistakes long after I have made them. I recently realized that I wanted a join table between tables that were previously not directly related.


The file currently has three tables relevant to my question: "Session" and "Payment" tables are each directly related to a "Client" table. I previously thought that I had no need to relate sessions and payments. I was wrong. (this is where I dope slap myself)


To fix this, I want to create a join table between "Session" and "Payment", but I am concerend about the impact of doing so on the existing data (and relationships, scripts, etc) in my file.


I assume I need to:


1. Create a join table between sessions and payments.


Do I simply delete the old relationship between Clients and Payments or create a new table occurance for Payments?


2. Delete existing "payment" records and re-enter this data (assuming this will populate the join table)


3. Update all scripts, portals, etc. to work with the new relationship.


This "sounds" straightforward.


Did I miss any steps? Any problems I need to avoid? Any hints or tips in working with join tables?


I appreciate any guidance