Self-join query

[Martins]

I have created a client database in FM6 where there can be several client contacts within the one company, all sharing the same accounts data.

I want to make a one-stop entry layout in that one file, accessible in any of the several client contact records, that will enable me to enter/change/update accounts data once only and that will automatically update all the other records.

I don’t want to create a separate file and create a relationship that way – I would prefer to keep it simple and all in one file.

Have I explained it adequately?

One idea I had was to choose a “Main” record among the several records, enter the Accts details in a special layout page and self-join to that to the other records using a secondary “Accts details” page.

Is there a better way? I have just upgraded to v8 but haven’t converted the files yet.

Any ideas?

Thanks for your anticipated help.

Martins

[mr_vodka]

Trying to do it in one table (file in your case) is not the right way to go. If anything and each company has multiple accounts, you should be creating another table for accounts.