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 correct information from other DB

Featured Replies

  • Newbies

I created a "Faktuur" system. (Faktuur=List of work done by customer, and the cost). This is related to a DB with Name and Adress data (Contact DB) of all our customers. The faktuur gets the name etc from the contact DB, which works good.

Now i created a payment reminder. It's a sheet in the contact DB wich is letter form in which several items are editeble, it auto adds current date in the letter and name. I created a relationship that allows me to have an pulldown menu in which you can select the fakturen which the client has with us, and whether or not he payed them. I used a Debet Nr, which is auto-assigned in the contact DB and used in the factuur to identify the customer. So this pull-down menu shows all fakturen with thesame debet nr, and thus thesame customer.

Next i created a short summary of the faktuur, with the subtotal taken from the faktuur, than createde a calculation to add the adminstrative cost (usually 15,-) and BTW and add them all up to have the amount that the customer needs to pay. My problem is that for this calculation it needs to take the amount of the factuur previously selected with the Factuur Number, but it takes the first factuur it finds, instead of the previously selected one.

First i thought i add a relationship with Factuur Nr, then the calculation works but it can no longer see other fakturen with thesame debet nr.

I hope i explained the in a way people here can understand, i will be happy to clarify anything that is unclear.

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.