Associated Records Issues III

Associated Records Issues III

Date: 20/08/2009 This note deals with the "Company/Staff" Tab in the "Contacts Layout":

We are dealing with “Companies” and with “People” – not just with “Company / Staff” as this would exclude Tenants or Engineers (Electricians, Gas, Builders etc.) for example.

Whilst on the subject, maybe there should indeed be a (Optional) Tag next to each Record, so that users will know what is the connection of every Associated Record with the currently browsed Contact.

Basically, you split "Company / Staff" from Associated Company merely on the basis that the "Company / Staff" Tab will be dedicated to people being associated with a Record through being employed there.

It follows that there should be a separate Tab for each Type of Association: "Landlord / Tenant", "Engineer / Us" and "Family Members"

Date: 20/08/2009

Maybe you should rename the Tabs “Associated Company” and “Company – Staff”, to “Company” and “People” respectively.

There are two reasons for this:

The word “Associated” is purely for your own needs, as the whole purpose of this Tab is to Associate Records.

Once the development phase is finished, every user will be trained in to know that the Tabs below the Contact Form deals with Associations of Records

Date: 24/09/2009

How is it possible that a property is listed under the Order Tab and not under the Properties Tab?

See Flat 6 Supton Court Podwall House Estate, Upper Clacton Road LONDON SE5 8JX

Date: 21/09/2009

We need to make sure that employees are only employed by one company.

Motty Feldman is employed by Palmline (for Foundation Road) and by Dacelinx (for Daycell Road).

When I want to place an order for Daycell Road, it shows me the company name Palmline instead of Daycell Road.

It's not the end of the world for me but someone else who doesn't know might invoice the wrong company and then we look like lemmings!

27/02/2013

Menasche Scharf

Ask FileMaker (or anyone else) how to turn a flat file database (as in an Excel Spreadsheet or the current Formulations Table) into a Relational Database See: http://forums.filemaker.com/posts/abd8500018