Noob question. Relationship lookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Titus A Ducksass - AKA broken-record - 28 Nov 2004 20:28 GMT

I have 2 Access tables, each with a field called ref_no, how do I get
to show only records related to the record selected in table 1?

Table 1 ref_no = autoinc, long int
Table 2 is of type number, long int

ie T1 ref_no=100
T2 Ref_no=100 rec 1 rec 2 .... rec 99 etc
T1 ref_no=101
T2 Ref_no=101 rec 1 rec 2 .... rec 99 etc

?????
Don't know where to start, keep getting a data type mismatch.

<A message to top posters. Type your reply here>

Signature

Never be afraid to try something new. Remember that a lone amateur
built the Ark. A large group of professionals built the Titanic.

Reply to this Message

Harry Strybos - 29 Nov 2004 20:39 GMT

>I have 2 Access tables, each with a field called ref_no, how do I get
> to show only records related to the record selected in table 1?
[quoted text clipped - 9 lines]
> ?????
> Don't know where to start, keep getting a data type mismatch.

I think you are looking for a query. Try:

SELECT T1.Whatever FROM Table1 T1
INNER JOIN Table2 T2 ON T1.ref_no = T2.ref_no
WHERE [condition]
ORDER BY [Field1], [Field2] etc

Reply to this Message

VB Forum / General 2 / November 2004

Noob question. Relationship lookup