relationship with

P

prem

I have created a small database and have linked
relationships together. But when I need some info, no data
is avaialble for display Something wrong with the linking
of the relationship and I am really not understand how to
link the table with relationship.
Please provide your valuable help
Thanks
Prem
 
J

John Vinson

I have created a small database and have linked
relationships together. But when I need some info, no data
is avaialble for display Something wrong with the linking
of the relationship and I am really not understand how to
link the table with relationship.
Please provide your valuable help
Thanks
Prem

How are you trying to make the data "available for display" - with a
Form? a Query? or what?

Relationships may not do what you seem to be expecting. Establishing a
relationship, with referential integrity enforced, PREVENTS you from
entering incorrect data - it does not automagically add data to any
table. If you have TableA related one to many to TableB, and create a
Query joining TableA to TableB, you will see (using the default join)
only those records where there is a matching value for the joining
field in both tables. If there is no data in TableB you will see
*nothing at all* in the query.

Please post back describing your tables, how they are related, and
what you're doing in an attempt to see the data.

John W. Vinson[MVP]
(no longer chatting for now)
 
Top