Simon K

Hi John Purpose is to handle graphics - (long explanation) I have 10 interface files (separated) from 1 data file I have 10 buttons (graphics) across the top of most of my windows as a main nav tool Each button runs a script that "goes" to a separate interface file (one for contacts, tasks, projects, products, timesheets etc). Each file has a colour associated with it. If a user is in a selected file the button outline changes from grey to the specified colour So that I don't have to (hard code and recode this) - all of the graphic objects are repeating global fields - referenced using a number for each file that relates to the repetition Hence when you change between files you need to reset the global button outlines back to grey so that you can reset the button of the destination file to the correct colour All I was wondering is if there was a quicker/more clever way to reset all repeitions to a single value than my experience allows thanks

Just a quick one I think... Is there any quicker/slicker way of setting all repetitions of a global field (to a single value) other than by a script that loops through the repeitions uses set field to set the repeition to the required value? eg set variable $c; 1 Loop Exit Loop if $c = 10 set field globalfield[$c] = "default value" set variable $c; $c+1 End Loop Many thanks

Hi all I would very much appreciate some pointers on how best to achieve the following: I would like to be able to produce a "proposal/quote" document. In my db at the moment there is an "estimate header" table and an "estimate line items" table. A proposal document has the following sections(structure) Intro Restatement of customer objectives (text - this could be more items in the line items table) Summary of costs (a table with 3-5 rows)eg: Software----------value (total of software line items) Hardware----------value Services----------value Development-------value Total-------------value Not all sections appear every time After the "summary section" there is a sub section for each of the major headings so in "software" there would be preamble (text items again) and a table of software modules, qtys and prices (ie from line items table) At the end of the proposal document would be a terms section and some appendicies eg price lists. Should I look at creating multiple pdf's and appends? Any pointers really welcome TIA

Hi all I have a "calendar" table which includes a date field (there is an entry for every date in a year) It also includes various calculation fields relating to that that date. One of the calc fields is a Short month/year field - ie so that 1/10/2009 would be "Oct 2009" (as would 2/10/2009) I have a conditional value list of the short month names year field (based on going back a calendar year from todays date) BUT because the short month name/year field is a text field it sorts alpha - I would like it to sort in month order and must confess to being a bit stumped I have tried sorting the relationship but that didnt make any difference Any help most welcome TIA

try taking a look at EZxslt - it worked really well for me ... ezxslt

Hi Vaughan Many thanks - have just updated this machine to 10v3 and the problem is still there (and this is on brand new files only written in 10 ie not converted from 9) - I am bemused - other people had this problem - just need to know what they did to stop it happening

I know its a while ago now - does anybody have a solution to the black blocks? - does it need an upgrade? or does everybody just ignore it? Many thanks PS I should add that, for this post please note this is now on vista with fmpa 10.0 v1

I have created an external data source to SQL server and created a TO of that table in FM and related it to my FM contacts table: Contacts::sl_accounts_code (FM) = SL_ACCOUNTS::cucode (SQL Server ESS) I am now able to see Sales ledger accounts info relating to my FM contact on my FM layout So far so good If i change a piece of data in the SQL Server from a FM layout - it updates beautifully into SQL server - excellent But if I then update a piece of info in SQL server it does not update the FM layout (even after changing layouts and reperforming a find on the customer concerned) In a nutshell : As a test i put the sales ledger account name on a contact layout - changed it in FM and the field changed in accounts db on sql server - then changed it back again in accounts app and it doesnt update the fm layout until fm closed and reopened... In fact it looks as though it only updates the SQL data source on restarting FM Have I missed a setting somewhere? TIA Simon in FM

It should indeed be simple - if they are linked on a client id (do check that the customer selected did indeed have some credit cards) - Do also check that you the link is indeed on id in both sides of the relationship - also check that the drop down list is is using the id as the first field and the credit card as the second (only show second will work better with a pop up) BUT - you have a much bigger issue ... and I certainly don't want to teach you your own business... under PCI-DSS rules nobody is allowed to store the security code - at all - not even if you believe you can store card holder data by complying with PCI rules So maybe a rethink on what you are storing and what you are using it for - if the idea is to recharge you would be much better using one of the "token" based system from an approved intermediary (even they don't store the sec code though) hope this helps PS - up to now PCI-DSS rules have been perceived as only applying to larger co's - but the reality is that the "credit card" cos are being much more aggresive now - and progressively seeking to apply the rules to smaller cos

Have you checked the field behaviour options "go to next option using" setting... (in layout mode right click on the field and select field/control..behaviour) deselect "return" and "enter" hth

Hi Fenton That seems to have done the trick on the sliding of the containers (I take it you meant the reduce size of enclosing part needed to be selected). It looks as though I need to "fiddle around" with the positioning in each page but its nearly there Thank you

Hi, I have a product table which has 10 container fields within the table (to hold a varying number of imagers per product) - [yep they probably should have been put in a separate table but they weren't - have to accept that pro tem!] I would like to produce a report that shows the images one per page. I am happy that the report will only be run for one product at a time. I have put 5 (out of max 10) containers in the body part of a report (one per landscape page) ie so that they are as big as possible and retain their perspective. I have also set all 5 to "slide/reduce enclosing part." The problem I have is when there are only 3 images (say) - I am still getting 5 pages in the report (2 of which are blank except for the header/footer). Any suggestions please Thanks Simon

Many thanks Michael - I will try that - I can see that the calc field needs to go into the timesheets table

Yes - I agree "empty" was a misnomer see below In each sub summary part is the relevant field (eg customer name in the customer sub summary part) and a subtotal of hours. What I would like is each customer to start on a new page and each project to start on a new page unless its the first project when it should start on the same page as the customer sub summary. As you say if you put a page break in before each customer and before each project it does that literally - which means the first page for each customer is "nearly" empty just containing the customer name - which is a waste of paper - (especially for all the single project clients) and divorcing the customer name from its projects. Its not the end of the world I just wondered if there was a way of making the report slightly more digestible

Its probably been asked before... If I have a report that is sorted and summarised by 3 fields In this case Customer/Project/Deliverable I would like a page break before each customer and before each project - but not the "first" project for each customer as that creates an empty page? How do i configure the part set up? Many thanks