I am developing an application in MS Access 2010. I have two tables Parts and NSN. NSN is a child table of Parts. Below are the table definitions.
NSN.NSNID, NSN.PartsID, NSN.Description.
I need to add a part and then add an NSN record. I need to get the Parts.PartsID form the Parts form when I open the NSN form.