Create a recursive relationship for a field in the same table
Operating system version
M/S XP pro
Description of the issue
I want to create a one to many relation ship with in a single table. ex - An Employee table that also shows which employees report to which managers (who are of course also employees themselves) - one manager, with 0 to many employees reporting to him.
I understand relational theory, and have created databases using SQL.
Steps to reproduce the problem
I can't find how to change a relationship type (1-1, 1-M, N-M) in Filemaker 11 Pro, Trial copy. I assume that the trial copy is a fully functional version.
I've searched online and found a "solution" that shows a way to modify an existing relationship, and also shows how to designate the type of relationship when creating it for the first time, but I don't see the same step options when I'm in Filemaker Pro, working on my table design.
Exact text of any error message(s) that appear