makerbert

multi column primary key possible in FM?

Discussion created by makerbert on Jul 22, 2014
Latest reply on Jul 28, 2014 by makerbert

Hello, I'm quite new to filemaker but been fiddling with databases for 10+ years.

 

I have to set up a database in filemaker. First table holds four (4) unique department names. Second table holds several thousands of subdepartment codes. subdepartment codes are not unique, but the combination departmentname-subdepartmentcode is unique.

 

using Oracle I would create a one to many relation from the department table to the subdepartment table en a compound primary key consisting of the fk_departmentname and the subdepartmentname. Is something like that (primary key from two columns) possible in FileMaker or am i thinking in the wrong direction?

 

Any views are welcome.

 

Bert

Outcomes