Results 1 to 3 of 3
  1. #1
    monvani is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2015
    Posts
    6

    Table > Field > Lookup > RowSource

    tblB (buyers)
    buyerID, First, Last
    b01, Bob, Smith
    b02, Susie, Quinn

    tblJ (jobs)
    jobID, buyerID (buyerID is a lookup field on tblB)
    j01, b01 (bobs job 1)
    j02, b02 (susies job 1)


    j03, b01 (bobs job 2)

    tblC (charges)
    buyerID, jobID, amount (buyerID is a lookup field on tblB, I want jobID to be a lookup on tblJ where buyer ID matches the input buyer on tblC)
    b01, ____ >I want a drop down with J01 & j03, but no j02 since that's not Bob's job

    I want user to input a charge against a buyer, and after that buyer is selected from drop down, I want that charge assigned to one of that buyer's job. I am looking for this to be a defined requirement in the table field lookup row source criteria, but it will not query down the results with a WHERE clause.

    trying something like this in tblC jobID field lookup row source:
    SELECT tblJ.jobID, tblJ.buyerID FROM tblJ WHERE (((tblJ.jBuyer)=([tblC]![buyerID])));

    But not working...

    It's like the select statement can't recognize the tblC buyerID that has already been selected by the user?

    I know how to fix it in a form, but because of the architecture I'm using I want it defined in the table. Any help please????!!!

    Thanks, Marcus

  2. #2
    monvani is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2015
    Posts
    6
    basically filtering down, like if I input a state in field 1 and I want only the cities of that state in field 2

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It sounds like you are trying to create cascading look up fields. I don't believe you can do that. I say "I don't believe" because I never use look up fields (different than look up tables) and have never tried it. But from what I know about look up fields, it is not possible..
    See

    The Evils of Lookup Fields in Tables
    http://access.mvps.org/access/lookupfields.htm

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

Similar Threads

  1. Replies: 5
    Last Post: 01-23-2015, 03:38 PM
  2. Replies: 5
    Last Post: 07-08-2014, 07:47 AM
  3. Replies: 3
    Last Post: 05-31-2014, 11:37 AM
  4. Lookup a field from another table?
    By yeleek in forum Reports
    Replies: 6
    Last Post: 06-08-2012, 08:43 AM
  5. RowSource Value not writing to the Table
    By tbassngal in forum Queries
    Replies: 5
    Last Post: 09-03-2011, 12:16 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
  •  
Other Forums: Microsoft Office Forums