One field table

[tinan]

Hello,

More or less, I am a newbie with filemaker. I have received an assignment to develop a database. Had no prior training with the software besides from looking at training tutorials.

In one of the tutorials, a database with relationships is laid out. Here is the scenario:

A table contact has a foreign key from table client a.k.a. clientID. Foreign key (clientID) in table contact is related with an instance in the database called contact_client.companyName which contains one field.

My question is, what is the use of the described scenario and how do we make a use of them.

Thank you for any help,

Tina

[Fenton]

Do you mean a field on a layout, which you clicked on while in Layout mode? (likely). In that case, contact_client.companyName likely means:

The "companyName" field in the Client table, being viewed from a layout of the Contact table, via the "contact_client" relationship. The name of the table occurrence (TO), on the Relationship Graph, is "contact_company".

It can also be deduced that the table occurrence group (TOG) on the Relationship Graph is anchored by a table occurrence (TO) of the Contact table.

A TOG is just a bunch of TOs that are connected in some way. In the "anchor buoy" method of relationship graph structure, each primary entity (thing -) has its own TOG.

If the field was in a Company TOG, being viewed from a Contacts (client_contacts TO), it would likely just be named, "company::companyName".