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
Click to expand...

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