I can not seem to figure out how to go about doing this in Access, in Excel this would be extremely easy.
I have two lists, one for mechanical parts and one for electrical parts. Both tables have some common fields, (i.e. part number, description) but also have a number of other fields that are not common (i.e. cable type, cable length). I would like to have a master table that lists all the parts from both tables along with the common fields. I need to keep the two tables separate because of how a variety of excel and visio files pull information from the different tables. I wouldn't be opposed to having a report of the two combined tables either. Any help for this access newbie would be greatly appreciated. I couldn't seem to find what i was looking for in the Access for Dummies book.