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.

Getting information from related table

tottijohn
in Relationships

Featured Replies

I have a layout form, A, with several fields like the following;

Restaurant Pax Rate Total

1.

2.

.

.

10.

Each field is individual, meaning there is a total of 40 fields for the above example.

The (restaurant field) is a dropdown valuelist from the next table, B. This table allows user to input the rate for each restaurant, so that the rate will be automatically fill-in when the user selects the restaurant in form A.

For single record, i can simply relate both tables (restaurant field) and use the (rate field)from table B in form A, but for this case, i can't since each (rate field) in form A is unique, for account purposes. Anyone can enlighten me on this?

Move your data into a related Items table - 10 related items for each record in A.

  • Author

Sorry i don't get what you mean, can elaborate abit more?

  • Author

Thats awesome!

One more qn though, is it able to do a total of all the selected rates?

Yes, of course: a calculation field in the Main table (result is number) =

Sum ( MainDetails::Rate )

will do just that.

Note that for a printed report, you would use a summary field in the MainDetails table, and sub-summarize the report by Main.

  • Author

Thanks alot comment, finally got everything to work :D

Create an account or sign in to comment

https://fmforums.com/topic/48716-getting-information-from-related-table/
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.