![]() ![]() So I'm pretty lost at how to do this without running two finds on two tables to get the correct number then manually adding them together. Also if there are costs that occur between Jan 1 and Jan 15, even if there is no revenue in Table B that occurs between that period they should be included. This seems like it should be a simple problem, but every time I run a find on Table B list layout, it does give me all revenue from Jan 1 to Jan 15 but if the related cost occurs before Jan 1 then it includes those two and they shouldn't be accounted for in the formula. I have converted an Old FileMaker Pro DB to Access. View 3 Replies View Related Query For Inexact Match Sep 19, 2005. I tried using the index, but it reconizes any/all of the fields that duplicate. ![]() The goal is to be able to calculate the cash basis for the period which is just cost + revenue for the period. This would work if I could get the table to not duplicate if three of the fields are the same as an existing record. Select the Edit Layout button on the Status Toolbar 2. Now what I'm having difficulty with is running a find that gives me all the Costs in Table A and all the revenues in Table B for a specific period. Making FileMaker Pro Your Office Companionpage 8 1. fp5 Files FileMaker Pro 12, 13 or future versions won’t open a. Drag and drop your old file on the FileMaker Pro icon, or from the File menu select Open File. Table A = > Table B (One to Many Relationship). You need a copy of FileMaker 7, 8, 9, 10 or 11, which will open the file in. The second, table B, has dates, unique codes and revenues. Or choose Manage Database to create a new field, table, or relationship. To choose a field in a related table, choose the table from the tables list above the list of fields. Tables can be created on Wikipedia pages using special wikitext. The first, table A, has dates, unique codes and costs. In the Specify Field dialog box, select the field to insert. A table is an arrangement of columns and rows that organizes and positions data or images.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |