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.

How to lookup only on the current found set?

Featured Replies

How can I set a script to re-lookup only in the current found set?

Actually what is the best way to Create a new invoice record for every existing costumer record and do a (re-)lookup? confused.gif

Relookup always works on the found set. And, why would you need to do a relookup? Relookup what, from where?

As far as creating the invoices, just import the Customer IDs. If you're wanting to duplicate current invoices, then duplicate them in a loop, and clear the non-duplicating fields; or, if there's a lot of those fields, then set the current ID into a global, create a new record, and put the global in the ID; then omit the original record (or both records, then find the new ones).

This isn't very clear; but then it's not clear to me what you're wanting to do.

  • Author

I am managing an Office/Apartment complex. Every month I need to invoice all the current tenants, many of the invoice charges items like rent are recurring, I need to find a way how to create an invoice then lookup the charges (one-time and recurring) for that tenant. Every month I need to create a new set of invoices for all the then existing tenants.

I would think you would just Import the entire Rentals table into a line items table every month, with the Rental ID and the rent due; and the ID or person responsible for the rent. I don't know about other charges. Those would come from another small table, but would also come into the charges table, to keep all the money in one place.

You could use a loop, but when you're dealing with a large group of records, import is the most direct. Mind you, Import has been a bit buggy in 7.

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.