Results 1 to 3 of 3

Thread: Design Query

  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unhappy Unanswered: Design Query

    Hi,

    I designed a db for orders. An order exists of one or more positions (lines) and each position can be delivered separately. Now, I want to make an invoice containing all orders and positions that have been delivered.
    Eg: order #521 has 3 positions (1, 2 and 3). Positions 1 and 2 have been delivered, 3 not yet. My invoice of order #521 should contain position 1 and 2. When position 3 is delivered, another invoice will be created. Remark: the invoice number depends on the delivery note (inserted manually).
    Any ideas?

    Thanks!

  2. #2
    Join Date
    Apr 2004
    Posts
    61
    Gee, it all depends on the structure you have. Not enuff info to help. How about a sample file w/little or no data?

  3. #3
    Join Date
    May 2004
    Location
    Melbourne, Australia
    Posts
    23

    Lightbulb

    Hello BrunoDG,
    In order to produce invoices that list only those items that have been delivered, you will need to have an item status field on the item records that record whether they have been delivered yet.

    Then I suggest you include a calc which references the invoiceID conditionally based on the item status. Eg:

    If( ItemStatus = "Delivered"; InvoiceID)

    The create a relationship from your invopice table to the items table which matches to the above calc. Only items that have a status of delivered will be addressed via this relationship. Now base the invoice layout that you want to print from on the new relationship and it should work as you've described.
    -------------------
    Ray
    FileMaker Developer
    http://www.nightwing.com.au/FileMaker

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •