Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

possible to show multiple instances of same record in portal?

Featured Replies

Is it possible to show multiple instances of same (non-duplicate) record in a single portal? I assume this isn't possible but I thought maybe I could use a join table or something? 

What is it you're trying to achieve?

  • Author

It took me a minute to figure out how to simplify my explanation, but I'm essentially trying to create a hierarchical, parent-child outline structure within a portal where some parent-child-sibling sets of records in the chain may have distinct parents/ancestors. I think I'm just going to duplicate those chains since there are a couple of other wrinkles in my set up that make that it a better course of action.

 

But the perceived benefit of using the same records in the portal is that when I modify these records, I wouldn't have to modify the duplicate chain in a separate step. This is just for a personal database I've been working on and it's somewhat of an experiment. I just wanted to know if it could be done or not so I could put that implementation idea to rest.

 

Thanks for the reply.

Well, thats sounds interesting. Why don't you post a sketch of the desired output? I'm sure someone will have to say something about it.

 

As to your original question: I wouldn't advocate mistreating your data structure or introducing redundant data just for display purposes, and so would conclude that you can't produce this outline model with your run-of-the-mill relationships and portals.

 

But this is FileMaker, where there is (almost) always a way to do it, and often more than one. To display certain 'special relationships' between entities, you could collect the data and display them – in lists oder portals – using virtual lists (google that) with as many copies of your entities as are required, doing nice tricks (check out the demos on this page: http://www.excelisys.com/filemaker-tips-tricks-demos-downloads.php); this would also leave you free to edit the original data (since you can use keys into the original tables).

 

You could also use a web viewer, HTML and JavaScript – I'm pretty sure there's a bunch of jQuery visualization plug-ins that provide more or less what you need; this takes a bit more effort (relatively speaking) than just plain FileMaker, and depending on your needs could require a plug-in (for FM-JavaScript interaction), but once you've set up a framework (Web Viewer, scripts, HTML templates etc.), it's smooth sailing.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.