Could a database be created having layout No.1and No.2 both acess table No1. Yet layout No.1 can only access table No.2 and Layout 2 can only access table No.3. Where abouts are these linked?
So cound I have 2 contact managment layouts accessing different 2 separate customer databases but the same product database.
Maybe you should explain in a little less abstract way what you want to achieve.
In general terms, layouts in FM are based on a table (table occurrence really). So they will display data from that chosen context. You can additionally show data from other tables provided that there is a valid relationship between that first table and the other tables whose data you want to show. Data from those other tables is then shown in portals.
In what section of the filemaker programme are these linked?
For example how is the contact managment layout linked to the customers data table
You can create the relationships from different contexts, like:
CTable_occurrence1::key1 = CMTable1::key
CTable_occurrence2::key2 = CMTable2::key
Here you (must) use two different layouts because you have two contexts (table occurrences) from which to look into the respective CM table.
But you could as well use
CTable::key1 = CMTable1::key
(i.e. both CMTable1 and 2 are related to CTable)
Now you could use the same layout (based on CTable) with two portals. (But you'd still be free to use two different layouts,a s in the first scenario).
In the first scenario you'd have to use two occurrences of the Product table, one for each CTable occurrence; in the second scenario only one, because there only is a single CTable occurrence.
andrewtunit wrote: In what section of the filemaker programme are these linked?
"These" = tables?
Then that is on the Relational Graph.
File > Manage > Database > 3rd tab: Relationships
andrewtunit wrote: For example how is the contact managment layout linked to the customers data table
When you create a layout you have to pick what table it is based on. So when you create a contact management layout you would pick your relevant customers data table
This is the "new layout" wizard, the very first choice is what data it should display:
If you have an existing layout then you can change its context in Layout mode. Be careful doing this though because all existing fields on the layout will now become related records and may not show what you had intended.
Most actions in FM are based on layouts, all layouts are based on a Table Occurrence in the Relationships Graph. This notion is referred to as "context", and context is king in the FM realm. It's an important concept to understand completely.
You may find this tutorial to be helpful:
Tutorial: What are Table Occurrences?
Retrieving data ...