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.

Join Tables - Invoices & payments

Answers
in Relationships

Featured Replies

Most of the databases I create have been for scheduling, services, jobs. Generating stats etc.. Now I have an invoicing database I'm working on. Invoices, parts, customers all work well. Now I need to add a payment system so they can apply payments to multiple invoices. I created a payment table, to store check #, amount, reference. then I created a join table to hold the invoice# and payment id to break down the many to many relationship. I'm having a brain freeze trying to create the layout. So I can take one payment of say $500 and apply it many invoices. I just need an example file so a light bulb goes off. Can anyone point me in the right direction?

any help is greatly appreciated!!

  • 9 months later...

Is it possible you may post your solution if you improved on the one you linked to?

Create an account or sign in to comment

https://fmforums.com/topic/61937-join-tables-invoices-payments/
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.