gaby78

Hello m3nme: I created a new field (number) and ran the ReplaceFieldContent (new field = calc field) to populate it. It took FM a long time to populate the new field, the find was very fast. So the time gained in fast search is lost in slow RFC.

I know this was discussed before but I couldn't find a solution to my problem. I am trying to filter a table to show non zero balances where Balance is an unstored calc field. I know that searching an unstored calc field isn't a good thing but I don't know how else I can get the info I need. Please see attached Any help will be highly appreciated. To rectify: There is a mistake in the attachement: the seach is on Balance field (the calc field) and not on the TotBal field (the summary field). Thus The problem is: the seach is slow when I search the Balance field in Transactions. sorry the mistake. slowsearch.pdf

Thanks Colin for the feedback. Advice taken.

Someone told me the following: With a peer to peer networked DB a developer can still make changes (add/modify layouts/ fields/formulas/relationships, etc...) to the db while being used by other users. I don't know to what extend this is true and how risky/safe it is to modify a db while in use; I would like the opinion of the experts. Thanks

I see, Thanks Comment.

Once again I bow to FM gurus to tell me why my simple IF statements always return zero. See attached files. Thanks PayrollDeduc.ZIP

Thanks guys. It's just that FM is such a great tool that sometimes I try to make it do what it cannot do; this tells you that I am still a novice.

I apologize if this question is dumb but this is my first attempt to use FM and the web. I am just wondering if it is possible to use FM as a simple web authoring tool to create web pages: No fields, no data, no records, just 3/4 pages (layouts) with static info and hyperlinks to navigate from 1 page to the other. As a test I created a layout and tried to save it as HTML so I can view it with a browser but would not save. Does that mean FM can't be used as HTML composer or am I doing it wrong?

Tanks Comment; I'll got ahead and use 2 fields.

I have 4 fields: Date, Number, Name, and AlertField: Alert is an autoenter calc. I want it to return "Alert" in 2 cases only: 1- Date has been modified or Name has been modified -> Alert field to return "Alert" 2- Number is modified and exceeds 19 to return "Alert" (if modified and value is below 19 it's not an Alert) I was able to figure each condition separately but don't know how to combine them. For 1 - I have : Let ([X=Date; Y=Name]; "Alert") For 2 - I have : Case (Number > 19; "Alert") I have been trying to combine these 2 conditions in one expression but stuck. AlertField is as an auto enter calc because once the person in charge has taken these changes into account the field is cleared.

I have a several source tables (VendorA, Vendor B, VendorC, etc...) having the same fields: ProductCode, Price, etc... all linked to a Catalogue table by ProductCode. Catalogue table has similar fields: ProductCode, Price, etc.... Price in Catalogue table is looked up from one of the Vendor tables. A product code is unique to each vendor, in other words, Price in Catalogue comes from 1 table and 1 table only. Currently I have set Price field in Catalogue as calc with the expression: Case (IsValid(VendorA::ProdCode); VendorA::Price; IsValid(VendorB::ProdCode); VendorB::Price; etc...for all the vendors). I am wondering if there is simpler way/formula to pull the price from the appropriate table since a price cannot come from more than 1 table. I know it would be simpler if Vendor tables were merged into one, but for many reasons this cannot be easily done.

So simple, so effective :thankyou:

Please see attached. Thanks for helping. SumByTypeExpl.ZIP

Simple invoicing system with Parent table and LI table. In the LI table I have a txt field to indicate if the item is taxable. If taxable the user enters "T" otherwise leaves it empty. My problem is how (from the parent table) to sum taxable items only. I know I can create another TO of LI and link it to parent to obtain the total. I am wondering if there is a calc or custom function that can give me the total without resorting to an extra TO or extra fields in LI. I have tried the TypeSumField cf listed in CF library on the forum but it does not work all the time. Thks

Thanks for the help Bcooney Comment: the GetNthRecord trick was nice. :thankyou:

I am sure this was addressed before but could not find the thread. I have a columnar report that summarizes invoices by customer ID. I would like to have a GTRR button in the body to take me to the invoice. However, buttons don't work in preview mode. If I swich to browse mode I can't see the records. I have redesigned the report in list view, I can see all the invoices but they are no longer grouped by customer. Basically what I need is a report of invoices grouped customer ID with a gtrr button that takes me to the invoice or some sort of a work around to this issue. Thanks.

Superb, thanks a lot Comment Hello D J: During data entry errors happen; also I found autoenter calc field in portal that draws data from parent is not 100% reliable, sometimes the value does not compute.

The trouble with lookup and autoenter calc is that if the date in parent (Payment table) is changed, Date in child table (Payment_Details) does not update. I currently have Date in child table as an autoenter calc and have a script that loops through portal records to reset the foreign key to itself to update the value. It is a bit akward until I find a more elegant approach.

I am trying to show related records where the relationship is based on unstored calc. Please take a look at the attached file. Any suggestion will be highly appreciated. Thanks InvPmt.ZIP

I would appreciate it if someone could tell me how to step through the repetitions of a repeating field like this Go To 1st Repetition Loop Set a value Go To Next Repetition, Exit after Last Repetition Exit Loop etc... Thanks

I thought of printing from the parent but I needed an expert opinion before I go ahead a design a new layout. Thanks Mr. Vodka

Problem with Sales Report I have a report by Sales Rep generated by a script with GTRR from Sales Rep table to Sales table. My problem arises when a Sales Rep didn't generate any sales in the month. There is no sales records in the Sales table therefore his name does not appear in the Report (it's a columnar report sorted by Sales Rep with subsummary). Is there a way to show a Parent record (Sales Rep Name) in the report although it has no related record (no sales).

Thanks DJ for your reply. I like your suggestion. Thanks again

Window problem I have a data entry layout. I have a button that opens a new smaller floating window (400 x 400 px). I have a button in this small window to close it. The purpose of the small window is to display info while allowing the user to keep entering data in the main window. My problem is I can't get FM to keep the small window on top of the maximized window while still being able to enter data in the main window. I have searched this site to no avail. I am facing these 2 situations: 1) The small window stays on top of the data entry layout but I cannot select the data entry layout to enter data 2) The small window pops up but when I click on the data entry layout it disappears behind it.

Thanks guys; it see the difference now.