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.

Summarizing Data from Two Different Tables

PutneyBob
in Relationships

Featured Replies

  • Newbies

Greetings!

I have created a DB in FMP 8, that has many tables. Two of the tables (product_Sales and product_Inventory), both contain date, quantity, cost, etc fields.

How can I bring them together to show all of the inventory added and sales made during a particular time period? In other words, dump records from two diffenent tables into one big table to manipulate the data for reporting.

Thanks

Asked and answered here:

http://www.filemakertoday.com/com/showthread.php?t=12462

Create an account or sign in to comment

https://fmforums.com/topic/51124-summarizing-data-from-two-different-tables/
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.