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.

M to N relationships

Deeeep Mehta
in Relationships

Featured Replies

  • Newbies

Let me introduce my problem:

- Product Master info database with a related db of attributes (1 master to N attributes)

- Quotation db which links to Product db (M quotes to 1 productmaster)

- Quotation db has its own attributes (1quote to N attributes).

Right now I lookup the attributes of the related master and export them to file and import them to quotationattributes, but this is ugly and leaves files on the client.

Productmaster has an key var ProductID

Productattrib is linked via ProductID

Quotation has a key var QuotationID and is linked to productmaster via productID

Quotationattrib is linked via QuotationID.

Is there any way I can script so that the attributes from productmaster get copied to quotationattrib?

Why export-then-import? You can import directly; or you can go through a looping script and write the records.

Create an account or sign in to comment

https://fmforums.com/topic/72145-m-to-n-relationships/
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.