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.

Creating a new record and pasting related data from different dbase

Featured Replies

  • Newbies

I've been working on a database for about 5 months now in my free time. Back in April of this year, I was using FMP3.0 - now I have 5.0 (which is amazing) = and a relationship that worked in 3 is now not working in 5. Let me explain.

I have a CONTACTS database that contains customer info, addresses, phone #s, ...

I have an INVOICES database that contains new invoice data entry, shipping info and invoice printing capabilities

CONTACTS and INVOICES both have a CONTACT ID field and I have created relationships to each other within each dbase.

Now, within CONTACTS the user will find the customer they want and they have the option to autmatically create a new invoice. Push the button - and boom, you are taken to the INVOICES dbase.

Next, you are viewing the data entry screen which shows a newly generated and unique invoice number. Now, the info from CONTACTS (addresses and such) should be pasted within the common fields of INVOICES. Not any more!!

Scripts I wrote include:

CONTACTS= Create new invoice for this customer (THIS WORKS!)

INVOICES= Create new invoice number (THIS WORKS!)

What isn't working is the relationship. I've tried dropping the relationship field in directly and I've tried using merge fields. Nope. No good. WHAT HAPPENED? Maybe I did it. Probably...but I don't remember messing it up.

I can email someone the two dbases if you'd like. They total 500k. crazy.gif" border="0

Create an account or sign in to comment

Important Information

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

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.