Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Normand

  • Rank
  1. I have a Contact layout (table Contacts) which also displays a portal (table ContactTypes) allowing the user to enter many contact types for a Contact. I need to make sure that at least one record is always entered by the user in the portal for each contact that is created or modified. Where should I put this validation on the Contact layout, and what would be the commands ? Similarly, I would need to create a script that would scan all Contact records, and create a record in the portal (ContactTypes) for this contact if none was found. The new record created would be assigned a static c
  2. I would need to create a small script where the field name (1st argument) in a Set Field command in the script would be passed by a parameter when calling the script. Something like: SET FIELD [ Get (ScriptParameter); 0) ] I can pass the 2nd argument (value) as a parameter and it works ok, but I can't figure out how to do it for the field name. Is this possible ? For the moment, I'm passing the field name as a parameter, and doing a CASE with a SET FIELD for each possible field I'm going to need, but I'm hoping there is probably a "cleaner" way of doing this. Thanks
  3. That's it ! It works great. Thanks to both of you.
  4. Is it possible to specify the name of a field to be printed on a report layout using a script ? I have a report that has to be printed 6 different ways. The 6 reports are almost identical, where the only difference resides in the name of 1 field that changes in each of these reports. So I would like to create only 1 layout instead of 6, and use a script (or whatever technique appropriate) that would get the proper field name to print, based on a selection made by the user. Is this possible ? Thanks.
  5. We have a 5.5 database that we loaded in FM 8.5 and saved as a fp7 database. When we load this database in FM8.5, it takes forever to load before we get to the first window, approx 1 minute. The file is 5 Mb. Is there a way to find out what is slowing the loading (step, log, debug, etc ?). When we load the original 5.5 database in FM 5, it loads normaly. Thanks.
  6. But how do you get the present sort order. I could not find any Get function which seemed to return this information ?
  7. I would like to display on a layout the order in which the table is presently sorted. If the sort selection is changed, this field would reflect the new sort order. How can this be done ? I tried with a global field and the Get(sortstate) function but this only tells me if the table is sorted or not (0,1)- doesn't give me the field name. I'm also looking for a method where a user could select the sort fields from a dropdown list (where I would put only a few fields-not all of them), and have the sort run after having done the selection. Thanks for your help
  8. Sounds very good, and looks much safer too. So I will remove the invoicing information from the subscription table and put it in a related invoice table using SubscId and InvoiceId. Thanks very much again !
  9. The need for NextInvoiceNo: In a "Subscription" table, the user would press on an "Invoice" button to indicate that this subscription can now be invoiced, which would assign the next available invoice number to this record, flag it as having been invoiced, and then print an invoice for it. I guess I should try to see if this NextInvoiceNo could be somehow auto-entered, and maybe even stored in the Subscription table instead of in the Settings table maybe ? Question: can a regular field be defined as auto-enter with a sequential number, but be only assigned when requested, instead of
  10. I have a general FM relationship question: I have a one-to-many relationship between my table City (one) and table Contacts (many) so that I can select the city from a drop-down list when entering the address in the Contacts layout. I need your opinions about if the relationship should be using a Auto-Enter serial no field assigned to each City, or simply the City name ? I think, in a general view of database relationships (and please correct me if I'm wrong), that it would normally be considered more "efficient" to store in the Contact record the SerialNo field of the City (or
  11. Ok. will do. I'm curious about what would have been the effects of defining the fields as global storage instead of normal storage in this case. What kind of problems it would have created ?
  12. Thanks both for the comments. Sorry, I mixed "global variables" with "global storage fields" - getting there.... Thanks for the clarification. So if I understand this well: 1) Should put my setting fields in a Table, in 1 record, as regular storage variable (not global). 2) Define a cartesian relationship (I will try to read more on this after this post) between the Settings table and each of the tables where I might need to have access to the settings fields. (}:|) This leads me to another question (if you don't mind): I'm worried about the part where user A is about to post a
  13. I will need to save general settings for my application ie: NextInvoiceNo, NextPONumber, SalesTax, etc. They would need to be accessed from many different places in the application. Should i store them in its own table (ex: settings) in one record only - use global or regular variables ? What is the recommended way of doing this ? The application will be accessed in a multi-user environment (3 PC,s - 1 Mac - No dedicated FM server). Does that have an impact if I use global variables ? Thanks
  14. I can't believe the efforts you guys put in when replying to our posts ! Really amazing. Thanks very much ThatOneGuy for the sample db. I am going through it presently and will let you know how I'm doing. Before receiving your post, I was able to get it working following jteich's advice - I added a self-joined relationship in the Coaches table for status = "Active" (see details in my previous post). Now your solution does not use a self-joined "technique". What is the difference / advantage.
  15. Thanks jen. I followed your indications and it now seems to work ok. What I did: added a self-joined relation in my Coaches table specifying that Coaches:status = Coaches:static_active (calculated field containing "Active"), and used this relation in my CoachesValueList to filter the records (include only related values starting from:). Is this what you had in mind - the right way to do it? The only weird thing is that I had to change the calculated static_active field to "Unstored". Without doing this, I could not get the drop-down list to display a list of coaches when on an empty field
  • Create New...

Important Information

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