Relationship with tables
give the query for using primary key and forign key between tables in filemaker pro 11. (please give with example)
table Client (idClient, name)
table project (idProject, IdClient, name)
in File --> Manage --> Database, (relationship onglet) u need to link the to fields Client::IdClient and Project::IdClient
in this case if u wanna set a layout to display related records from the two tables
It sounds like you want to manipulate a SQL expression from with in a script to create different relationships between tables. This is not possible in FileMaker. If you give an example of what you are trying to do, we can likely suggest an alternative approach to achieve the same result.
What you can do is use a script to query a table or group of related tables to bring up a found set of records on a specified layout. This is roughly analogous to a Record Set you might produce in MS Access, for example.
ok i telling about my problem;
i m working with FileMaker pro 11 & m using FM ODBC driver 220.127.116.11
i create Connection with existing FM database and create a new table in that existing database using create query this doing right work.
my Primary Key syntax is working right but when i fire the Foregin Key syntax then this shows error.
Eg:CREATE TABLE ORDERS (Order_ID int Primary Key,Order_Date date, Customer_SID int, Foreign Key (Customer_SID) references CUSTOMER(SID));
In the above example, the Customer_SID column in the ORDERS table is a foreign key pointing to the SID column in the CUSTOMER table.
then the relation is not creating b/w tables. So what should i do now?
Is another metho to do this for filemaker database.
pls help me about this....................Have a nice day.
You are trying to create a new table where? in the source database or in FileMaker? If in FileMaker, don't think this is possible. If in the ODBC source, I don't know--haven't messed with ODBC in FileMaker so don't have a lot of experience in this area to go on.
thanx for replay....
actually my concern is that i want to create relationship by insert and update query with primary key and forign key.
so plse help me to give the query statement for filemaker database.
m using FM ODBC driver 18.104.22.168
I m facing as same type of problem,
In Window environment we used ADO and his function for Automation of database.
Eg: for creating Relationship in columns for given tables we used CreateRelation() ADO function.
Same in this manner on mac how would this will possible,i have no ADO and no API for FileMaker pro 10 and 11 on mac.
pls help me about this.
Have a nice day to you.
Retrieving data ...