Matching exact data

[MisJ]

Hi I have built 2 tables: tblMain and tblPartNo. They are linked by Drawing
numbers. I want to find all Part numbers that are also drawing numbers and
later on run a report to show that once I click the top drawing number,
everything else will show up as well. Could you please point me to the right
direction?

My tables contain the following columns:

tblMain:
DwgID
DrawingNo

tblPartNo:
PartID
DwgNo (linked to DwgID in tblMain)
PartNo

Thank you in advance.

 

[vanderghast]

Have a report based on tblPartNo. Open the report with something like:

DoCmd.OpenReport "ReportName", WhereCondition := "DwgNo=" & DwgID


to have a report displaying only the parts that are refering to DwgID trough
their DwnNo field.

(I assume DwgID is a number, not a string).


Vanderghast, Access MVP