Skip 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.

Lookup Fields

Sari
in Calculation Engine (Define Fields)

Featured Replies

I've got 3 tables: tbl_Quote, tbl_Quote_Line_Items and Estimate. Basically the user enters a breakdown of what they think a job will need in the estimate. They don't necessarily use the figures in the estimate for the quote, it is just a rough guide. However, bought in items entered in the estimate table are used.

I am trying to do a forecast layout based on table estimate but I need the actual quote total (Summary field) which is in tbl_Quote_Line_Items. I seem to be having difficulty getting it to display.

I've tried defining a lookup field in tbl_estimate to get the quote total from tbl_Quote_Line_Items so I can use a summary field to get the information I need but that doesn't work either.

Has anybody got any solutions that don't include a gun to the head?

Thanks

Its hard for us to give an answer without seeing your file, or at least a stripped down example.

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.