I have 2 tables, parts and products. but they are not linked, part-nbr is same notation as product-nbr. I have a chart with fields from parts and I want to bring one of the attributes of the product table. but when I do this it creates a lot extra rows with all the products not included in the part table, how can I just populate the attribute for the current parts in the table? How is the statement for a conditional? or is there any other way I can do this.
Parts-Nbr Desc
1120 11awg
2280 22awg
3020 30awg
4578 45awg
4560 45awg
4512 45awg
7854 78awg
Products-Nbr Width
1120 .12
5879 .36
3548 .21
2280 .35
3020 .58
8542 .65
4578 .87
3698 .65
4560 .45
4512 .12
7854 .85
I want my output to be:
Parts-Nbr Desc Width
1120 11awg .12
2280 22awg .35
3020 30awg .58
4578 45awg .87
4560 45awg .45
4512 45awg .12
7854 78awg .85
This is just an example there are so many other fields and tables. I can not rename the fields.
Thank you.
