I'm still new to Microsoft Access, and have seen 20 posts that start exactly this way, but I still haven't figured it out.
I have 2 forms I need to link together. I have 2 tables: "proposals" and "revisions". The user should be able to input several revisions under 1 proposal so these tables have a 1 to many relationship. I would like the user to go into a proposal, click a button called "Create New Revision" and open the Revision form so that the user can enter the data which will be automatically linked to the parent form/proposal data. I know it should be simple bc Access is based on this sort of thing but for the life of me I cannot do it. I am still using Macros so is there a way to do it with that?