Just curious if FMP is simplifying (graphically) the concept of SQL Queries using TO's and Relationship graphs?

For example -

If I have 2 tables in a database - Customers and Invoices,

Would creating a TO based on Customers be the equivalent of saying in SQL

SELECT * FROM Customers

And making a connection between Customers and Invoices in Relationship graph would be the equivalent of the rest of the SQL statements like

SELECT * FROM CustomersTable, InvoicesTable

WHERE CustomersTable.CustID = InvoicesTable.CustID 

AND

CustomersTable.DateOfCreation ≥ "1/2/2006"

If you use ESS then the tables are essentially "brought in" to the FileMaker solution, and you can use them as FileMaker table occurances - FM will take care of all queries on your behalf.

Right, misread the question, the answer is yes, but you do not have access to anything but that graphical representation.

Note that the queries are also taken care of when you perform search's etc.

Edited October 5, 200718 yr by Guest

Sh..orry Im Sho drunk.

Shpank You.

riiiiighhhhtt...