Pretty simple (I think) update question. Tbl A has Unique (one) ID number for multiple ID's below Tbl B (could have) Multiple ID numbers for Tbl A above How would I get the correct results if I make a change in one ProductID record without receiving all the Product ID's assciated with table A ID NUmbers. Example: Table A will only have one ID number. But table B could have multiple ID's related to one of the Table A ID numbers. I just wat the results to only one record in table B and not all of them taht are associated with table A ID number.