Search results

Hey Guys, Thanks so much for all of the feedback, I've made a few changes and have a couple of questions. Rain - Thanks so much for the explanation of primary keys it was really clear and helped me re-think my design and putting it together with the suggestions Plog gave me really helped...

Okay, so right now I do have a one-to-many relationship between the institutions table and the applicants table, so what you are saying is that I just need to add an autonumber to the institutions table and have it as the primary key. So the grant is assigned to the applicant, the money is...

Hi Guys, Thanks for all the feedback, I really do appreciate it. I used the InstitutionsName as the primary key in the Institutions table because I thought by doing that it would reduce redundancies and not allow users to enter erroneous institution names. In the applicants table each row is...

Hi Guys, So I attached a screen shot of the relationships I've established so far. I'm having difficulty figuring out how to have certain fields auto-populate. I want the applicants table to be the first place information is entered, and I want the InstitutionName to auto-populate (for...

Thank-you all for your help and suggestions. I'm going to go through the links, and work through it slowly as suggested. I'll post a screen shot of the relationships once I get there. Thanks again!

Hi Everyone, I could really use some advice. I'm interning for a non-profit and am creating a database to hold all their grant competition data. This is the kind of info i'm dealing with: 5 different grants (GrantName) (there's repetition in this column) Several investigators (ApplicantName)...