Results 1 to 4 of 4
  1. #1
    mbarnesca is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    5

    Query removes number choice/ranking

    Is it possible that a query can limit or remove number as an option after it has already been selected in prior choice.



    For example

    1) User has to rank in order their selection from a list of 3 products.
    2) After User selects first choice (1) the remaining list of products only allows choice 2 and 3 left to chose.


    In this instance there can not be two choice for #1 for example.

    CHOICE PRODUCT
    APPLE
    1 ORANGE
    PEAR

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    yes in principle, but the solution depends on your table, query and form design. Explain what you have and we can see want can be suggested.

  3. #3
    mbarnesca is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    5
    Click image for larger version. 

Name:	Untitled.png 
Views:	4 
Size:	20.6 KB 
ID:	26255I struggled trying to modify Northwind as there are so many interconnected forms, queries, subforms. I'm hoping to build from overly simplified beginning and build on it. For example.

    I have 1) Inventory, 2) Buyer and 3) Orders.
    If Buyer selects from inventory it should go into the Orders Table(Append Table?)

    I am most familiar with Design View when I great queries. However if there is a SQL code I can copy that does this that would be great no matter how simplistic. Easier for me to build up than trying to modify large intricate databases (Northwind) that has some many interconnected parts.
    Attached Thumbnails Attached Thumbnails Query.PNG  

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you can always look at other templates which are simpler than Norrthwind. I would also google normalisation and take at the links on post #11 of this thread

    https://www.accessforums.net/showthr...738#post335738

    At the moment your table design looks completely wrong - I would expect something like

    tblProduct
    ProductPK autonumber
    Product name text (apple, pear etc)

    tblBuyers
    BuyerPK autonumber
    BuyerName text (Jim, Tom, etc)

    tblTransactions
    TransactionPK autonumber
    ProductFK long link to products
    BuyerFK long link to buyers
    TransactionType text (on order, delivered, opening stock, sold etc)
    Quantity number

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 06-28-2014, 08:28 PM
  2. Replies: 2
    Last Post: 04-11-2013, 06:36 PM
  3. update query that removes extra letters
    By alinapotter in forum Queries
    Replies: 4
    Last Post: 04-06-2013, 01:15 PM
  4. Associate Number with Each List Box Choice
    By beribimba in forum Access
    Replies: 8
    Last Post: 08-25-2011, 08:31 AM
  5. Adding table to Query removes every 4th record
    By CoachBarker in forum Queries
    Replies: 1
    Last Post: 10-13-2010, 07:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums