one to many relationship

[victora]

Hello everybody:

I have 2 tables in a 1 to many relationship. I like to print all records in my '1-table' that are not in the 'many-table'

What type of link shall i used?

Thanks

VA

 

[Transcend]

Hi there,

I take it you have a setup like so

Table1 Table2
--------- ---------
Table1ID Table2ID
Table2ID Description

and you want all the table2ID's that do NOT appear in table1??

Hope this hasn't confused you .. but anyway

Select Table2ID From Table2 where Table2ID not in
(Select table2id from Table1)

Transcend

 

[Transcend]

Ack sorry got a bit confused, they way I showed you above, gets the data in a query then your report will display the data that you want. If you want to do the suppressing on the actual report you do it differently.

How are you getting the data to your report?

Transcend

 

[victora]

Transcend,
My main table is a membership master (key is member#, unique) then my other table is a plan history (key is also member#, duplicates allowed).

I want to list membership records without a plan history.

When u use the visual link, what type of link can i used?

thanks
VA