More understanding on linking table and make a grid query

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

I learnt from this forum that relationship of the query does not have to be
the same as relation of the table.

Can anyone explain to me more, whether all the table we have should setup
relationship one to the others?. I found it that like the gender table for
example, when I make relationship with the member table would stop my combo
box. So neither relate it nor we put it on query would even better and my
combo works.

I need more explanation from all the experts in this forum.
 
Hello,

I learnt from this forum that relationship of the query does not have to be
the same as relation of the table.

Can anyone explain to me more, whether all the table we have should setup
relationship one to the others?. I found it that like the gender table for
example, when I make relationship with the member table would stop my combo
box. So neither relate it nor we put it on query would even better and my
combo works.

I need more explanation from all the experts in this forum.
Click to expand...

You should have a relationship defined between two tables if there is a
relationship, in the real world, between the entities represented by those two
tables.

I have no idea what you mean by "relationship with the member table would stop
my combo box". I'm not there; I can't see your application. I would presume
that the real world relationship between the two tables - assuming that the
Gender table is a one-field, two-row table with records M and F - would be:

Every member has one and only one Gender
Each Gender can apply to zero, one or many Members

Therefore there would be a one to many relationship from Gender to Members,
linking on the Gender field as the primary key of Genders, and a foreign key
Gender field in the Members table. This shouldn't stop anything from working.

Could you explain your current table structure, what relationships you tried
to create, and the symptoms of the "stop working"?

John W. Vinson [MVP]
 
Back
Top