Relationship problems in access ;-)

  • Thread starter Thread starter Mercedes
  • Start date Start date
M

Mercedes

Hi everybody,
I have some trouble understanding acces and I don't seem
to be able to make it do what I want it to do.

Situation:

Table Projects
ProjectID
Projectname
Startdate
Grant J/N

Table Grants
GrantID
Grantgiver
Grantapplicant
ProjectID
Grant iven J/N

There is a relationship between Projects and Grants for
ProjectID because practically every project has a grant
application. However not every grant is granted.

Problem:
Whenever a grant is granted I want to see in my projects
list wether is has a grant, and more important what GRANT
ID is has. So there needs to be another relation between
porjects and grants showing me the grantID based on the
criterium wether the grant was succesful.

Solution
That's where you step in. Please help, thanks
 
To recap the thing I would like to accomplish with access:
It would be something like this

IF the value in (Grants)(Grants awarded Y/N)= Y; then
(GrantID) should be coupled to project ID (there would
have to be a field "GrantID" in the table "Projects"); IF
the value in (Grants)(Grants awarded Y/N)= N; there would
be an empty record in the field.
 
Create a query that Links the table Projects and Grants by the ProjectID,
add criteria where the [Grant].[Grant iven J/N] field is J. (I assume that
J is an English 'Yes'.)
 
Mercedes

Are you saying you want a query that displays grants, and whether or not
they were "granted"?

This is not a "relationship", as Access uses relationship to show how tables
are related, one to another.

What happens if you create a query against your grants table, and display
the "granted?" field?
 
Back
Top