Relational Database structure query
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