Yeah, big issues. You need to fix your tables before you move on to forms. In fact, forms are the last thing to work on. After you get your tables set up you should work on Reports to make sure you can get the data out of your database like you need.
Read up on normalization (https://en.wikipedia.org/wiki/Database_normalization
). That's the process of properly structuring your tables. I see a lot of things wrong with your tables, I will hit on the big items:
Improper Use of Primary keys. Primary keys (e.g. ProjectName.ID, ProjActivity.WAID, ProjDetials.PMID) are used to connect tables. The primary key of one table becomes a foreign key in another table, thus linking records in the two together. You have primary keys in your table (as listed above), but you are not using them. You have ProjName as the link between ProjectName and ProjActivity, that is incorrect. There should be no ProjName field in ProjActivity, instead you should have a ProjID field in ProjActivity and store the ID value from ProjectName there. You did this with ProjDetials as well.
Storing Values in Field Names. In Funding you have a ton of fields storing forecast data (e.g. 0FY01Q1Forecast) which should not be in that table. They should be in a whole new table set up to accomodate the data. Data needs to be accomodated vertically (with more rows) and not horizontally (with more columns). Every piece of data that is jammed in those field names need to go into their own records of this new table.
You've got 12 fields for that forecast data. All of them come out and go into a new table with just 5 fields:
ForecastID, autonumber, primary key
TransID, number, foreign key to Funding.TransID
ForecastFY, number, this will hold the fiscal year value that is currently in the field name
ForecastQuarter, number, this will hold the quarter value that is currently in the field name
ForecastValue, Currency, this will hold the actual value stored in the field right now
So instead of 1 record with 12 columns for your forecast data, you will have 12 records in this new table to accomodate it.
You've stored values in field names in quite a few places (TotHr_Qtr4, 1stFundDt, etc.)
So, read up on normalization and do it to your data. Once done, complete the Relationship tool again and post back here your new database.