Search results for query: *

Dawn - the "box" character is ASCII 29. There are several ways to solve your problem but the easiest way is to create a calculated field concatinating the contents of the repeating field - separating them with a unique delimiter that is unlikely to be used in data input (for Windows pcs I use...

2 Quad Espressos later ................. If you're completely controlling input (with scripts) you can ensure the contents of the 2 fields are valid before the users can exit the record being created/edited. Otherwise, you can only WARN the user not to proceed. Create a calc field cValidAmts...

Sorry - still half semi dazed from all the driving I've been doing this week :( I'm awaiting a LD call so can't tie up the phone line; I'll get back to you shortly. Bill

If you're completely controlling input (with scripts) - it's easy enough to prohibit duplicate entries but if users are enabled to use FMP menus (I NEVER permit that!) you can only WARN the user not to proceed. Create a calc field cConcat (text result, stored) to concat the contents, Field A & "...

Well Stephen - certainly you easily export the data from FMP7 files to FMP5 files but AFAIK no-one has yet written a plugin to convert the FMP7 file structure (i.e. retaining the fields, layouts, relationships etc). Bill

Bob - I'm on the road right now so I can't check this out (and as it has been a couple of years since I used the FMPS DOS commands so my memory is a little fuzzy). However, if you open a DOS window, go to the folder in which the fmpserver.exe file is located and type the DOS command fmpserver...

>I assumed that opening the file on my desktop >would do the trick Simply uploading the file back to the server's folder isn't sufficient. You need to have the FMPS application (not the FMP application) "serve" the file before you can open it. Bill

My guess is that you don't intend to enable an OPTIONAL response in the product description field but that you want FMP to autofill that field with a "standard" description (based on the Product ID). If that's the case, I'd favour creating an additional file - being a lookup table with a...