g.bevan Posted March 30, 2001 Posted March 30, 2001 Hi, My intranet makes quite heavy use of FMP4 databases which are published using custom web pages and quite a lot of CDML to call scripts in the databases etc. I upgraded to FMP5 unlimited because I wanted to publish databases that looked more like the forms created in the original database. FMP5 does this very well but (I have since learned) does not support scripts! I can replace most of the scripts with calculation fields but cannot think of a way to perform a search on multiple fields in the database without using a script. Basically, I need to use the contents of a single field to search multiple/all fields in the database. Can anyone offer any help or advice? - Thanks, Grahame.
Keith M. Davie Posted March 31, 2001 Posted March 31, 2001 http://www.filemaker.com/support/index.html Search and read: Article Number: 104829, and Article Number: 105687 Peace
Vaughan Posted April 3, 2001 Posted April 3, 2001 Join up all of the text fields into a calculation field (field1 & field2 & ...) then perform a single search on the calculation field!
g.bevan Posted April 3, 2001 Author Posted April 3, 2001 Vaughan - Thanks for taking the time out to reply to my question. That's an excellent suggestion (and lateral thinking ). I'll take your advice and amend my database accordingly. Grahame. quote: Originally posted by Vaughan: Join up all of the text fields into a calculation field (field1 & field2 & ...) then perform a single search on the calculation field!
Recommended Posts
This topic is 8626 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