Hi - I am new the forum and appreciate any help someone might be able to give. I am a self-taught Access user who is newish. I know all of the basics (I read through Microsoft Access 2013 in the Shelly Cashman Series). But I struggle with more complex maneuvering sometimes.
Currently I am trying to create a query that will auto populate data based on table relations:
In the most basic form...
I have two tables:
Location ID Location Name Price Family ID 560100 BLOOMINGTON IN PARTS SUPPLY R6200 560200 CENTRAL INDIANA PARTS SUPPLY R6200 560300 DALEVILLE PARTS SUPPLY R6200 560400 FORT WAYNE PARTS SUPPLY R6200 560600 PLAINFIELD PARTS SUPPLY R6200 560700 SOUTH BEND PARTS SUPPLY R6200
Item ID Item Description Location ID 001260! VENT, 8IN WALL BRACKET 400300 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560100 001260! VENT, 8IN WALL BRACKET 560200
I want Access to see if Location ID can be found in the second table (we will call it Indianapolis district) and referenced in the first table (called Test). Then, I would like it to apply the Item ID and Item Description being applied to 560100 in Test to every other site in the Indianapolis district table.
Currently all I have been able to come up with is:
SELECT [Indianapolis District].[Location ID], Test.[Item ID], Test.[Item Description]
FROM Test RIGHT JOIN [Indianapolis District] ON Test.[Location ID] = [Indianapolis District].[Location ID];
Location ID Item ID Item Description 560100 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560200 001260! VENT, 8IN WALL BRACKET 560300
560400
560600
560700
But what I want is:
Location ID Item ID Item Description 560100 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560200 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560300 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560400 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560600 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560700 #12DAMPER14! DISPLAY; 10-UNIT LOCKING COUNTER DISPLAY 560100 001260! VENT, 8IN WALL BRACKET 560200 001260! VENT, 8IN WALL BRACKET 560300 001260! VENT, 8IN WALL BRACKET 560400 001260! VENT, 8IN WALL BRACKET 560600 001260! VENT, 8IN WALL BRACKET 560700 001260! VENT, 8IN WALL BRACKET
Let me know if you need any other info.
Thanks!