buck.matthew74's articles:

Items(88) /9 Next >> Last >|

Copy data from table through a relationship - set field 8 62 (1/24/2012 6:54:50 AM) comp.databases.filemaker Prelim As many know, in a business one has Quotes and Orders. Quotes might become Orders but not necessarily. Quotes have many of the same data fields as Orders, however, creating Quotes on the Orders Table is... Buckbuck

Relating data 6 45 (12/12/2011 10:34:34 PM) comp.databases.filemaker FM11 I have a Receivables database. Each Receivables has a date field, Date_Payment, indicating the payment date. I also have a Foreign Exchange database showing the midday exchange rate for US and Cdn dollars.... Buckbuck

Creating pdfs of a found set. 1 48 (8/3/2011 10:45:39 PM) comp.databases.filemaker FM8.5 Is it possible to loop this script to create a set of individual pdfs (by InvoiceID#)? Go to Layout (xxx) Print Setup Show Custom Dialog (PDF Option) If (Get ( Last message choice) = 1 Save Records as P... Buckbuck

Portals - Found Sets 1 49 (6/15/2011 2:35:39 PM) comp.databases.filemaker FM10adv I would like to create a portal on an ORDERS layout (table ORDERS 2008) that shows a 'found set'. For ease of use I want to design a layout with the Order form on the left and a Tab Control to the rig... Buckbuck

Portal - Sorted 1 48 (5/18/2011 9:26:04 PM) comp.databases.filemaker FM 10 advanced Is it possible to create aportal that shows a selected result. The context is an INVOICE layout within or adjacent to which there is a portal showing all Invoices. This portal creates the list t... Buckbuck

SubSummary by Month 3 66 (4/3/2011 7:43:06 PM) comp.databases.filemaker FM10 I am trying to understand how to create a report that summarizes my Sales revenue by month. I have a Date Ordered field so I am guessing there is some way to create a field that gets the month data from th... Buckbuck

script for/covering more than one field 0 265 (2/11/2011 4:35:02 PM) comp.databases.filemaker FM10 I have a script attached to a button that formats the text for a 'Format Text' field. I use this to paste and contact information into my Contacts database, paste the text into 'Format Text', format tex... Buckbuck

Modify last found set 4 55 (11/18/2010 5:21:27 PM) comp.databases.filemaker FM 10 I have a field with a Value List checkbox (Yes) that allows me to create a custom found set. I perform a find for those fields with the value "Yes". How can I create a button that will reset or clear the... Buckbuck

Sub summary lists - missing values 3 41 (11/17/2010 6:45:06 PM) comp.databases.filemaker FM 10 Pro I have a sub summary report sorted on Account Class. When I look at the subsummary in both Browse and Preview mode some of the values (dollar amounts) do not show. Is there an obvious reason for this... Buckbuck

Calculation #5 4 39 (11/12/2010 12:33:11 AM) comp.databases.filemaker FM8.5 I am trying to create an Invoice field with a calculated result. When a Contact field is valid (a tax number exists) the Invoice field checkbox defaults to Y, otherwise N. My attempts do not work. Can a... Buckbuck

buck.matthew74's replies:

Items(34) /4 Next >> Last >|

Layouts - select criteria is date 4 38 (5/28/2010 9:20:08 PM) comp.databases.filemaker FM8.5 Is there a way to create a layout for a CHEQUE LOG that shows only records within a specified date range as its default. I have an accounting system with a CHQUE LOG table. The layout currently shows rec... buck.matthew74 (131)

Relationship query 3 57 (6/4/2010 11:52:22 PM) comp.databases.filemaker FM8.5 I am trying to define the relationship between three tables CONTACTS, INVOICES and CHEQUE LIST. In my setup (and I do not know whether this approach is best) I have created a CHEQUE LISTt table separate ... buck.matthew74 (131)

Summary sub summary query 3 49 (6/12/2010 6:02:47 PM) comp.databases.filemaker FM8.5 Is it possible to create a sub summary report that omits specified results. I have a Ledger. Each record is classified according to a chart of expenses (production, shipping, bank fees etc). I want to om... buck.matthew74 (131)

Formatting text 5 40 (8/3/2010 8:59:46 PM) comp.databases.filemaker FM8.5 Is it possible to creat a script that will automate font and size formatting of all the contents in a field. I copy and paste info from websites and I need to reformat all to keep some consistency in the... buck.matthew74 (131)

Date #3 3 42 (11/9/2010 11:44:28 PM) comp.databases.filemaker FM8.5 I want to create a calculation result with a parameter , Create Date is more recent than September 29, 2010. Would this be Create_Date > 29/09/2010? My calculation is: Account_Date_Create > 29/9/2010 an... buck.matthew74 (131)

Calculation #5 4 39 (11/12/2010 12:33:11 AM) comp.databases.filemaker FM8.5 I am trying to create an Invoice field with a calculated result. When a Contact field is valid (a tax number exists) the Invoice field checkbox defaults to Y, otherwise N. My attempts do not work. Can a... buck.matthew74 (131)

Modify last found set 4 55 (11/18/2010 5:21:27 PM) comp.databases.filemaker FM 10 I have a field with a Value List checkbox (Yes) that allows me to create a custom found set. I perform a find for those fields with the value "Yes". How can I create a button that will reset or clear the... buck.matthew74 (131)

A list portal on a table layout 4 46 (4/11/2011 6:46:01 PM) comp.databases.filemaker FM 10 I have an INVOICES table. I have a table layout. I want to create a list view of all the Invoice records (kp_InvoicesID) through a portal so that I can see the most recent 20 Invoices within any Invoice.... matthew3640 (5)

Relating data 6 45 (12/12/2011 10:34:34 PM) comp.databases.filemaker FM11 I have a Receivables database. Each Receivables has a date field, Date_Payment, indicating the payment date. I also have a Foreign Exchange database showing the midday exchange rate for US and Cdn dollars.... buck.matthew74 (131)

Copy data from table through a relationship - set field 8 62 (1/24/2012 6:54:50 AM) comp.databases.filemaker Prelim As many know, in a business one has Quotes and Orders. Quotes might become Orders but not necessarily. Quotes have many of the same data fields as Orders, however, creating Quotes on the Orders Table is... buck.matthew74 (131)