I have two tables Table1 & table2.
Table1 is a list of part numbers table2 is a list of possible locations.
I would like to create a table by combining them with the locations and only the parts from table1. However when I do this I am getting all the possible locations for table2.
In excell I would use a Vlookup and after I pasted the unique values. How do I accomplish this in access ?
Table 1 Part
Part1
Part2
Table 2 Part Location
Part1 A1
Part2 B3
Part1 Gt
Part1 X4
Part4 Gr
Part7 Xx
Table 3 Part Location
Part1 A1
Part2 B3
All I want is the chance to prove money won't make me happy.
Table1 is a list of part numbers table2 is a list of possible locations.
I would like to create a table by combining them with the locations and only the parts from table1. However when I do this I am getting all the possible locations for table2.
In excell I would use a Vlookup and after I pasted the unique values. How do I accomplish this in access ?
Table 1 Part
Part1
Part2
Table 2 Part Location
Part1 A1
Part2 B3
Part1 Gt
Part1 X4
Part4 Gr
Part7 Xx
Table 3 Part Location
Part1 A1
Part2 B3
All I want is the chance to prove money won't make me happy.