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.

importing data

sboard0599
in Relationships

Featured Replies

I have a DB that has individual records for each user and application on his or her workstation. For example, record 1 is user 1; application A; record 2 is user 1; application b; record3 is user 1 application c. I want to create a new DB that will gather all the info and let me see, in one record, all the software on user 1's machine, reading something like user 1; application a; application b; application c. Any ideas out there?

  • Author

Thanks, but I just cant seem to get these portals to do anything for me. II am really just guessing on how they really work. Could you give me more detilaed info? I am looking to combine many records into one, listing a user and all the software on his machine. I now have 2o records all listing the same user, each record showing a different program.

quote:
Originally posted by sboard0599:

Thanks, but I just cant seem to get these portals to do anything for me. II am really just guessing on how they really work. Could you give me more detilaed info? I am looking to combine many records into one, listing a user and all the software on his machine. I now have 2o records all listing the same user, each record showing a different program.

Your best bet is to get a book on Filemaker, particularly one dealing with relational design aspects, as this is a very big area to cover in a few words.

quote:
Originally posted by sboard0599:

I have a DB that has individual records for each user and application on his or her workstation. For example, record 1 is user 1; application A; record 2 is user 1; application b; record3 is user 1 application c. I want to create a new DB that will gather all the info and let me see, in one record, all the software on user 1's machine, reading something like user 1; application a; application b; application c. Any ideas out there?

How about a portal based on a self-relationship in this file such as gUserID::UserID where you just type in the UserID into the global field and the self-relationship displays all apps for that user.

Or you could create a report that shows the information.

Create an account or sign in to comment

https://fmforums.com/topic/3845-importing-data/
Go to topic listing

Important Information

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

I accept

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.