Alpha Video Training
Results 1 to 2 of 2

Thread: Stock Control

  1. #1
    Real Name
    David Corcoran
    Join Date
    Oct 2001

    Default Stock Control

    I have a database based on the alpha sports invoice module. I want to extract from two different child data file both on sets of one - many relationship.

    My question has any one got ang sugestions on how I construct the set so that I can get all the items from the "out" field in "invoice_Items" and all the items from the "in" field in "Stock_rcv_items". I set up a new set with the parent "products" and the other two as child with one to many relationship but cannot design a repor that will give me a summery of the fields "out" and "ins" for each individual "Product_Id" but it does not work. The purpose of this report is to give me to give me a result of how much we bought and invoiced for each product over a given period. Hope someone can help.

    Kind regards

  2. #2
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Boston, MA

    Default Re: Stock Control

    Your post belongs in the Database Design forum.

Similar Threads

  1. stock control
    By dcorcoran in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 08-22-2007, 06:54 AM
  2. stock control system need help
    By Peter Wade-Graham in forum Alpha Five Version 6
    Replies: 5
    Last Post: 10-05-2005, 09:20 AM
    By Nev Kent in forum Alpha Five Version 5
    Replies: 2
    Last Post: 09-29-2004, 04:48 PM


Posting Permissions

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