Here is what I want to do. I have a table called "Proposals" and a table called "Projects". I want to take information that is already in the Proposal table and populate it in the Projects table. The information in the Proposal table is several fields but I would like them to populate in automatically in the Project table when I input the Proposal Number. The Proposals table has proposal numbers for example 15P132 but they do NOT correspond with the Project number example 15A132. Those can be two different things all together.
Here is the scenario: I have a "Proposal" or bid that we were awarded. Now I input the information into the "Project" table. This is where I want to use the Proposal Number to auto populate certain fields. Like how much was our bid? The address? Etc..
Any help in this matter would be greatly appreciated. Thank you.