Alpha Video Training
Results 1 to 6 of 6

Thread: need help on screen design

  1. #1
    "Certified" Alphaholic
    Real Name
    Charlie Crimmel
    Join Date
    Apr 2000
    Location
    West Virginia
    Posts
    1,695

    Default need help on screen design

    I am designing screens for a tool inventory project.
    I am using a set with whseheader,whsetransactions and items.
    Items is a table that has all tools in inventory.

    attached is a sample screen design
    At the top is the whseheader information.
    On the left side is the whse transactions.
    on the right hand side I need to have the items in inventory show all the time.
    The user would then select(double click) from the items on the right and it would enter into the current record on the left.
    I tried a subform but I cannot get the link right.
    It is like a lookup but the lookup table has to be on the screen all the time.
    any ideas
    Charlie Crimmel

  2. #2
    Member
    Real Name
    Stephen Williams
    Join Date
    Apr 2000
    Location
    Oakland, CA
    Posts
    930

    Default RE: need help on screen design

    How have you spread the data across the tables? I am not sure why you need a subform if you have a meaningful set design..

    I would make a set along the lines

    Warehouse Parent field WHSID
    |
    ===>Items Child link WHSID
    |
    ===>Transactions Child link WHSID+Incoming = .t.

    Then the warehouse info goes on the header and you have two embedded browses. One of Items in stock, the other incoming transactions. Double click an incoming transaction and it creates an item on hand.

    My question is how did the incoming transaction data get into a table? Couldn't that operation include making them on-hand? Or do I misunderstand...

  3. #3
    "Certified" Alphaholic
    Real Name
    Charlie Crimmel
    Join Date
    Apr 2000
    Location
    West Virginia
    Posts
    1,695

    Default RE: need help on screen design

    Steve:
    The warehouse header for receipts (tools comming into whse)has :
    transaction number(link)
    from warehouse
    from job

    the warehouse detail transactions has:
    transaction number(link)
    item number
    description
    quantity

    the item table has:
    item number
    description
    I want the item file to show all records in the table so the
    user can select the items to go into the warehouse detail transactions.
    TKS
    Charlie Crimmel

  4. #4
    "Certified" Alphaholic
    Real Name
    JohnZaleski
    Join Date
    Oct 2000
    Posts
    1,736

    Default RE: need help on screen design

    I think I understand what you are attempting, so for what it's worth here are my thoughts....I don't think you are going to have any luck synching the two one to many browses. In order to show all inventory items at all times you need a one to many set that links to your header record. To do this, just as an example,you would need a field on your header record with a value of "1" and a field on your inventory record with a value of "1". These fields would have no other purpose but to provide the link. Your other one to many set links the transaction number of your header record to the transaction number of your detail warehouse transactions. They are both related to the header record but not to each other making any kind of automatic synching impossible. You could probably write a script to take the id value of the currently selected item from your "all item browse" and put it in to the item id field of your warehouse transaction record when adding or changing transactions. This would be the only time the two records would be in "synch". If you wanted to display certain item values (description or unit of measure) every time you selected one of your inventory transactions you could either use the "Lookupc" function (pretty slow) or add a second link to the item file in your set using a one to one first match from the item id of your transaction. Good luck with your project.

  5. #5
    "Certified" Alphaholic
    Real Name
    Charlie Crimmel
    Join Date
    Apr 2000
    Location
    West Virginia
    Posts
    1,695

    Default RE: need help on screen design

    got everything working Ok.
    thanks for your help
    Charlie Crimmel

  6. #6
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,307

    Default RE: need help on screen design

    Charlie, how about a summary of your solution (for future reference)?

    Thanks.

    -- tom

Similar Threads

  1. On Screen Design and Programming
    By Hackey in forum Archived Wishlist
    Replies: 1
    Last Post: 10-28-2005, 11:13 PM
  2. Screen Flashes in Design Mode
    By Rick Canady in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-31-2003, 11:19 AM
  3. Set Design Help?
    By David Agan in forum Alpha Five Version 5
    Replies: 1
    Last Post: 06-27-2003, 04:18 AM
  4. SET Design Bug?
    By rtbtat in forum Alpha Five Version 5
    Replies: 6
    Last Post: 05-22-2003, 05:51 PM
  5. help set design
    By vasant panjabi in forum Alpha Five Version 4
    Replies: 1
    Last Post: 10-17-2000, 11:35 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
  •