I've got three tables that deal with our part numbers as the primary ID. One table is a 1:1 relationship with a list of manufacturers. This table also has a relationship with a components table that shows component type and sub-type, again based on our P/N. There is also a third table, in where I list a 1 to many relationship showing the part number and all the manufacturer's and their part numbers.
What I would like to do is take the form I created for adding a new component to the first table and expand the form I currently have, so that some added fields could enter the data into the second table. Is it I possible and if so, how would I go about doing this?
I will also say, I DO NOT program well, so if I need to add verbage to a macro, that would be step-by-step process for me.
Thank you,
Rebecca