I am a newbie. I need help very badly.
I have two tables: tblinventory and tblpartslist. I want to create a one-to-many relationship between them, and Access isn't allowing it. I have no idea why. The data types are the same, and there are 5 fields in each table that should correspond to each other.
I need to create a form from tblinventory, where I will need to enter parts records from tblpartslist. I would like to create a subform in tblinventory, where I will be able to look up records in tblpartslist by the product numbers, and enter them into a datasheet. Both tables have this field. I would like the information from tblpartslist to automatically enter into the corresponding fields in tblinventory, so that I don't have to enter the info in over and over.
I can't create an AutoLookup query, because I can't make a 1:m relationship.
I hope I'm being clear enough. Someone, please help me. I'm having a very hard time getting anyone to answer any of my questions, and I can only improve by continuing to ask. I have no VBA experience, but I'm really interested in learning more about it. I have to start somewhere... I need help from the experts!
I have two tables: tblinventory and tblpartslist. I want to create a one-to-many relationship between them, and Access isn't allowing it. I have no idea why. The data types are the same, and there are 5 fields in each table that should correspond to each other.
I need to create a form from tblinventory, where I will need to enter parts records from tblpartslist. I would like to create a subform in tblinventory, where I will be able to look up records in tblpartslist by the product numbers, and enter them into a datasheet. Both tables have this field. I would like the information from tblpartslist to automatically enter into the corresponding fields in tblinventory, so that I don't have to enter the info in over and over.
I can't create an AutoLookup query, because I can't make a 1:m relationship.
I hope I'm being clear enough. Someone, please help me. I'm having a very hard time getting anyone to answer any of my questions, and I can only improve by continuing to ask. I have no VBA experience, but I'm really interested in learning more about it. I have to start somewhere... I need help from the experts!