Alpha Video Training
Results 1 to 4 of 4

Thread: Set Design Problem using one items table in 2 sets

  1. #1
    Member
    Real Name
    Joe Nuccio
    Join Date
    Jun 2006
    Posts
    27

    Default Set Design Problem using one items table in 2 sets

    Our business sells replacement parts to repair electronic equipment. So, I have a set to create an Invoice when parts are sold consisting of the following tables:

    Invoice-header
    Customers…………1-1 link to invoice_header by customer-id field.
    Items……………1-many link to invoice_header by invoice_number field.

    This set works ok with no problems.

    We also do repairs of electronic equipment. To handle a repair, I have another set to keep track of this work consisting of the following tables:

    Repair_header
    Customers……………1-1 link to repair_header by customer-id field.
    Items…………… 1-many link to repair_header by repair_number field.

    I only want one items table to keep track of items ‘sold’ as a product sale only, and items ‘sold’ when used in a repair. I have been unable to accomplish this. so far

    Either it can’t be done, or,
    I do not have the necessary fields in the items table, or,
    I have not linked the tables in each set to the correct fields,
    or ???

    I have studied Alpha Sports and other applications in this forum, but so far I have not been able to determine if it can be done. It is one of the major problems holding me back from converting from A4v8 to A5v10 for our business.

  2. #2
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,649

    Default Re: Set Design Problem using one items table in 2 sets

    Quote Originally Posted by joe View Post
    I only want one items table to keep track of items ‘sold’ as a product sale only, and items ‘sold’ when used in a repair.
    Can you elaborate and clarify? Your statement is a little confusing

  3. #3
    Member
    Real Name
    Joe Nuccio
    Join Date
    Jun 2006
    Posts
    27

    Default Re: Set Design Problem using one items table in 2 sets

    Peter, a few weeks ago I found a revision to Alpha Sports.... probably on this board somewhere. It had a Quote Set added and it had a 'Copy to Invoice' button on the quote header form that had some interesting code on the OnPush event. This code was by Tom Cone dated 8/1/10. It could be the answer to my problem.

    So, I have revised my Repair Set to include a repair_items table, and have added a Copy to Invoice button on my Repair Set form.
    I am presently trying to revise Tom's code to work for my table and field names. I do not get any error messages when the button is pushed, but I do not see that it has created a new Invoice record either.

    I'm not sure where I found this revision to Alpha Sports

  4. #4
    Member
    Real Name
    Joe Nuccio
    Join Date
    Jun 2006
    Posts
    27

    Default Re: Set Design Problem using one items table in 2 sets

    A quick follow up. Tom Cone has answered my questions directly concerning script used with the "Copy to Invoice Set" button on the AlphaSports_modified.zip database. I have since modified his script to work in my App successfully.

    Many thanks to Tom and others who are trying to help me with the conversion from A4v8 to A5v10.

Similar Threads

  1. Problem with a Set design
    By joe in forum Upgrading to Alpha Five from Alpha Four
    Replies: 5
    Last Post: 09-05-2010, 10:15 PM
  2. Table/Set design options location
    By Peter.Greulich in forum Archived Wishlist
    Replies: 2
    Last Post: 06-01-2007, 01:49 AM
  3. Many-to-many relationship: table and set design
    By jmatienza in forum Alpha Five Version 7
    Replies: 18
    Last Post: 04-19-2006, 05:17 AM
  4. Master Form for Set, Design Problem
    By seaken64 in forum Alpha Five Version 7
    Replies: 5
    Last Post: 04-18-2006, 07:04 PM
  5. Set Design Problem
    By Peter.Greulich in forum Alpha Five Version 4
    Replies: 7
    Last Post: 06-17-2001, 03:15 AM

Bookmarks

Posting Permissions

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