Jump to content

Creating a new record and pasting related data from different dbase


This topic is 7767 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • 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

Link to comment
Share on other sites

This topic is 7767 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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