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.