AnsweredAssumed Answered

Relational Database structure query

Question asked by HugoLidia on Jan 2, 2014
Latest reply on Jan 2, 2014 by philmodjunk

Title

Relational Database structure query

Post

     Our database needs restructuring, as we currently have a clients file, linked to policies and to claims.  Separately we have a quotes file.  What we should have is that when we collect the quotation data, if it turns into a policy, that the associated client data does not need to be input again, but I can't get my head around how to restructure the files.

     Any advice would be appreciated.

     Environment - Windows 8.1, 3 Users, FM Pro Adv 12.04

      

      

TIS_DB_structure_01-01-2014.png

Outcomes