Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5642 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Probably not possible:

I have an EmployeeMaster table which is the source of a layout in form view. I would like to have a portal in the bottom of the form view that lists the Employees. In addition, and when a find procedure is used, it would list the found set.

Since the EmployeeMaster is the main table and not available as a related table, the EmployeeMaster table cannot be used in a portal. Is there one of those exotic tricks that exists to accomplish this task?

Posted

You can certainly relate a table to itself. This is known as a 'self-join', and is very common. You just need to use another occurrence of the same table on the relationships graph.

It's also possible - though not quite simple - to reflect the found set in a portal:

http://fmforums.com/forum/showpost.php?post/231005/

http://www.nightwing.com.au/FileMaker/demos8/demo804.html

http://fmforums.com/forum/showtopic.php?tid/197149/

However, I think in this case you could do something much simpler -see:

http://fmforums.com/forum/showpost.php?post/234951/

  • Like 1

This topic is 5642 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.