markga Posted August 21, 2000 Share Posted August 21, 2000 Hi, I'm new to fmp(5) but I really like it. I'm working creating a customer database. There are 2 files, one the customer file the other is a zip code file which will contain the city, state and zip code. What I want to know is how to have fmp automatically create the zip code record if it doesn't find a zip code match? Righ now if it does find a match it inserts the appropriate city and state in the proper fields in the customer file. But perhaps I'm approaching it wrong? Thanks! Link to comment Share on other sites More sharing options...
Kurt Knippel Posted August 22, 2000 Share Posted August 22, 2000 quote: Originally posted by markga: Hi, I'm new to fmp(5) but I really like it. I'm working creating a customer database. There are 2 files, one the customer file the other is a zip code file which will contain the city, state and zip code. What I want to know is how to have fmp automatically create the zip code record if it doesn't find a zip code match? Righ now if it does find a match it inserts the appropriate city and state in the proper fields in the customer file. But perhaps I'm approaching it wrong? Thanks! You would need to create some scripts to accomplish such a thing. Basically have your scripts fill in the field if a match is found, if no match is found prompt the user for the city and state information and add it to your zip code file. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www.database-resources.com mailto:[email protected] =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
markga Posted August 25, 2000 Author Share Posted August 25, 2000 Thanks, that works great. One question, how can I get the script to return me to the record I came from automatically when finished? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted August 26, 2000 Share Posted August 26, 2000 quote: Originally posted by markga: Thanks, that works great. One question, how can I get the script to return me to the record I came from automatically when finished? you never actually left that record, just Toggle Window (Hide) as the last step in the script and you will be back to the screen you started from. ------------------ =-=-=-=-=-=-=-=-=-=-=-=-= Kurt Knippel Senior Filemaker Developer http://www.database-resources.com mailto:[email protected] =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8838 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 accountSign in
Already have an account? Sign in here.
Sign In Now