Actually I have to create a main form for professors which has subforms of proposals and departments.( departments subform should be in such a way that I can select multiple departments). Also the proposals subform should contain 2 subforms awards and agencies. (agencies subform should be in such a way that I can select multiple agencies).
I am able to create only one subform in the main form using form wizard. But I am able to understand...

Hi all,
I am designing a database named grants in MS Access. It basically deals with
1) A group of people write a proposal for projects that they want to do.
2) The proposal is submitted to a funding agency for consideration.
3) At some time in the future, the funding agency may or may not accept the proposal and make an award to fund the project.
For this I have created 5 tables
1) Proposals: ProposalID(Prim ary...