May 3, 200124 yr 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.
Create an account or sign in to comment