AnsweredAssumed Answered

Create a recursive relationship for a field in the same table

Question asked by DavidMcClendon on Nov 4, 2011
Latest reply on Nov 7, 2011 by philmodjunk

Summary

Create a recursive relationship for a field in the same table

Product

FileMaker Pro

Version

11

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

N/A

Expected result

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.

Actual result

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

NONE

Outcomes