Forms + Subforms problems

[Maria83]

Oh, wait, I remember why I thought I needed it. Its because of the way the two table are related. The Awarded Grants table and the Fiscal Funding table were related by a one-to-many relationship using AwardedGrantID (in the Awarded Grants table) as the primary key and then using that number as the foreign key in the Fiscal Funding table. But when I went to create a form that will be used to populate the two tables, users had to fill the Fiscal Funding table using the AwardedGrantID numbers (which is the same problem I was facing with InstitutionID numbers). So I thought to create the junction table to eliminate the use of the AwardedGrantID on the form but to keep the relationship between the two tables.

Is this thought process correct?

 

[Maria83]

Based on my post #21, I don't think I'll remove the new junction table, unless I'm completely wrong and you think there might be a better way to solve my problem on the form.

 

[GinaWhipp]

Then your thought process looks correct and I would keep the Junction table. This is terrific, I beleive you are really starting to understand the tables and how they relate to each other!

 

[Maria83]

Thanks so much for your help! I'm on to the query discussion group, I'm having trouble pulling the all the data from my All Applicants table and Awarded Grants table. The query filters out the unsuccessful applicants in the All Applicants table, which I don't want it to do. I just want it to keep all the applicant data and then indicate GrantNumbers with the successful applicants.

Thanks again