Jump to content


  • Posts

  • Joined

  • Last visited

caveat1's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Dear sd, That's brilliant. I'll work with this approach. I'll be back here if I get hung up. Thank you!
  2. Seems so basic, but .. Can someone direct me to where I can find a Find and Delete Duplicates formula? I need: If Field A plus Field B in rcd 1 equals A plus B in rcd 2, delete all but most recent by Date Field C. TIA!
  3. Needing a formula or a join table, or? In an anchor-buoy table occurance scheme, I have job specs (some y/n, some multiple choice)in one table, service IDs and rates in another. (pt is to be able to change rates w/o changing formulas throughout). Got a nice calculation to relate job to svc ID. But I need a formula that says "if the svc ID from this job field matches this Svc ID in the rates table, use that rate." Getting a portal to do this has me flummoxed. Hints toward the right direction greatly appreciated!
  4. They are both number type. I tried to store and index the calc field, but cd__ilnDate is a calc field that references a related field so I can't store or index it. The table with the calc fields is a line items table for invoices. The related table is a royalties statement table, to pay royalties on sales of a particular item, falling within a particular royalty period. The royalty period is either January-June or July-December. There is a separate field for the royalty year. What I want to do is calculate the royaly period and year for each line item sold, based on dates on the invoice. The cd__ilnDate field references the invoice file with an if statement and gets the invoice date or the paid date, depending on the type of invoice. Then I broke the date out using the Month and Year functions. Now I want to relate the line items table to the royalty table with these 2 fields and the item number, in order to get the sales of that item that fall into that period. Is this possible? I thought I had the Year portion working in the relationship yesterday, but now can't get it to work either . Any help would be appreciated.
  5. I have a table with these 2 fields, both with Number results: cn__ilnMonth = Month ( cd__ilnDate ) cn__ilnPeriod = If ( cn__ilnMonth < 7 ; 1 ; 2 ) I am getting the correct results in the ct__ilnPeriod field. I am trying to relate this table to another by using this field and relating it to a simple numeric data entry field in the other table. It looks like something is must be wrong with the results of the Period calculation. I don't see any hidden spaces, so I am not sure what I am missing. Any ideas? Originally, I wanted the results of the calc to be "January-June" and "July-December." I have simplified it to 1 and 2 to figure out the problem, but get the same results. Ideally I would like to relate the tables by th values "January-June" and "July-December," if that is possible.
  6. Thank you for your response. I changed the permissions to No Access, but there was no change. Do I need to restart the host computer after changing the permissions? Also I was curious about your suggestion to put shared files in a container field. Do you mean that you would use a Filemaker database to manage shared files of any file type, rather than using the operationg system's directory of folders and files?
  7. Thank you all for responding. It sounds like I need to change the permissions on just the folder that the FMP database is stored in. That way we can all keep sharing the other files in other softwares through the OS. Once I Get Info on the host's database folder, what do I change the permissions to? PS - We are all running Tiger. When I go into System Preferences > Network, then click Built-in Ethernet and Configure..., there is an Appletalk tab. Under this tab, we have clicked Make AppleTalk active. This was one of the things our internet provider recommended to check to be sure we could all share our files through the OS.
  8. I don't know a whole lot about networking, so this is the little I know about our setup. It is peer to peer. On all machines, under System Preferences, the Network tab has Appletalk active, and the Sharing tab has Personal File Sharing checked. This is so we can all see each others' hard drives. It sounds like you are saying this configuration doesn't work with sharing FMP files. I'm not sure why the setup would work for one computer, but not another. Also how do you turn off file sharing for just one folder? Thanks for your help. Please let me know if there is something I am missing here.
  9. Hello, We have 5 Macs, one running FMP 8.0 Advanced, the other 4 running FMP 8.0. One database file is on the computer with 8.0 Advanced. I have turned Network Sharing On for All Users. Don't display in Open Remote is NOT checked. I open the file on the host computer. On another computer, I can see the host computer, but no files. On one of the other computers, running FMP 8.0, I have a database consisting of 3 files, and all other computers, including the one running 8.0 Advanced can open these files remotely. Outside of FMP, the computer with 8.0 Advanced can't see any of the other computers, even though File Sharing and Appletalk are on. The other computers can see this computer, however. I hope this makes sense. Do we have a general network problem that is obvious and could fix the FMP sharing issue, or could there be a solution in FMP? Any ideas would be great.
  10. Thank you so much, everyone!! That is so simple - choose New or Scuff, then separate them out with a calc. Sometimes the solution is so obvious, it is easy to miss. Thank you also, comment, for your link to the tutorial. It may be something I can use in the future. Thank you all again!
  11. Thank you for your suggestion. I tried these calculations and tested them. I can enter an amount into QNew, then enter an amount into QScuff. The amount in QNew disappears. However, if I go in the other direction, enter an amount into QScuff first, then an amount in QNew, the amount in QNew still disappears. (I would think this would make the amount in QScuff disappear.) Any ideas?
  12. I planned to use 2 fields in each line item record (one for new and one for scuff) and 2 fields in each product record (new inventory total and scuff inventory total). The inventory levels will calculate from several tables, including sales, returns, consignments, etc. Do you mean that each line item would have a category field, containing either the text "New" or "Scuff"? I thought about that, but am not sure how to calculate new and scuff inventory in my inventory table. Any thoughts on that would be great. (The products are books, "scuff" means the book is scuffed or damaged.)
  13. I have an invoicing/lineitems/inventory database. I want to track sales of new inventory, as well as sales of slightly damaged inventory of the same items. My thought is to have 2 fields in the line items table - QtySoldNew and QtySoldScuff. I want these fields to be mutually exclusive, that is, only one can have a quantity, not both. It seems like I need to have a validation by calculation that involves isEmpty or not isEmplty, but I am not sure what the calc would be. The idea is to enter the item #, then enter either a quantity under new or scuff, depending on which inventory it would come out of. Then I could set up 2 inventory calc fields in the inventory table to track both new and scuff levels for each record. Any suggestions would be great. Thanks, KC
  14. Hello, I have an invoicing database, with a related customer table. There is also a mailing list-type table that is used to track marketing contacts and send out targeted mailings to customers or potential customers. A third table holds information on authors. Any of the people in the three tables could become a customer that would have an invoice. Do I create duplicate entries in the customer table when people in either of the other tables buy something? If so, how would I keep their contact information up-to-date in both tables? Does it make sense to create one big table with all the fields from all three tables? In the other direction, customers could become people we want to put into a targeted mailing list in the mailing list table. I'm not sure how to handle these situations. Is there a standard way to handle this kind of thing. Neither of these options seems like a very clean way to manage data. Any ideas would be welcome.
  15. That was a simple solution to my lookup issue. I will have to learn more about committing records, in general. Thank you so much for your help. >
  • Create New...

Important Information

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