Matching exact data

M

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.
 
V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

table in query has no data 1
Selecting latest revision but with criteria... 12
Autofill columns with like data & bringing in new data 4
Extracting Partial Data from one field into another 1
Including all records from employees in a date range 2
Help with Top N query 5
Need some tips on the design of a database...(long) 4
Create form for 1:N relationsip 3

Top