Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Clarkmcfly

  • Rank
  1. I encountered a problem recently for a genealogy database that I'm developing. As an example, if I am to search for 1B's downlines (you can see on the illustration pic that I attached), I'm looking for a way to find all the "A" downlines strictly following the left connection (encircled) which should give a result like 1B->1BA->1BAA->1BAAA, etc. I'm planning to use a script for this type of search, but I came to a dead-end when I tried to solve this logic. What would be your approach to this?
  2. Hi, I'm currently developing a system intended for a retail company. When generating the catalog, the system needs to have thumbnail pictures that are arranged from left to right (say, 5 pics per row) with 3 lines of texts below each thumbnail to properly indicate the item code, description and price. This is intended to be viewed and printed. If I have only one container field to hold the pic for each product, how can I generate a preview of the item catalog following the layout format stated above? Many Thanks!
  3. Thanks for the information, Lee. Please be patient with me, because this is the only forum that I'm actually participating. I'll just be adhering to the rules. Thank you.
  4. Excuse the x-posting, but the purpose of the inclusion on the previous thread was simply to re-iterate the whole question that I asked previously to correlate with the topic being discussed. No deliberate violation is intended. By the way, I hope you could still give light to my inquiry. Thank you.
  5. No, I'm not double posting. I'm referring to the link on my previous post to further clarify the topic being discussed in this thread.
  6. Actually, this problem has been brought up when I came upon across the development of an inventory system that I am designing. The whole description for it can be found here: http://fmforums.com/forum/showpost.php?post/289654/ I already received a response indicating that the solution should be a transactional model approach. I am thinking of a simpler way and do away with creating another table to record each transaction if I can be able to perform the tasks below: FOR NEW TRANSACTIONS 1. Create a new transaction record 2. Check the transaction made for this item and dete
  7. Thank you for your response. I'm actually reviewing the link that you provided (I already had the article printed)
  8. Thank you very much for your response. I will study the references that you provided.
  9. Hi, I have a problem accessing the previous record on a found set that I need to evaluate. For an inventory that I'm developing, I need to know the value of, say the field QtyIn recorded on the last transaction. Please see the image below: http://www.designink.info/test/Case1.jpg I tried using the function GetNthRecord ( QtyIn;Get ( RecordNumber ) - 1) to get the QtyIn and passed it on the QtyInPrevious field just to have a reference to see if it's doing what it's supposed to do. You will also notice that on the left pane, the records are Unsorted and is displaying ALL the recor
  10. Hi, I'm starting up with creating inventory solutions for Warehouse using Filemaker. In creating the system, I haven't figured out how you guys deal with the approach on handling report generation using the following scenario: 1. I use a transaction table to record incoming/outgoing items, see sample below: WHEN PURCHASING OR ADDING NEW ITEMS Transaction Type: "Add" (this is just a marker so the system knows what type of transaction is being handled) Item Code: Qty: 10 (assuming this is the first time this item is encoded, remaining Qty=10 also) WHEN SE
  • Create New...

Important Information

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