I have many tables of different electronic parts types, all have xx_ID with autonumber and different field names. I would like to tie them all together with one table and create a relationship between tables. Each table is it own partType, with dropdown list table to add partsub type, connected one to many. I have forms for each part table. I can't quite get what I need, one new table Parts or two tables connecting them all. Please point me in the right direction, Thanks.