Relationship Problem

[kbiz]

Table1 has two fields that I want to link to the primary
field in Table2. My goal is to create a query that lists
data from different rows in Table2 for every row in
Table1. For example, if Table1 has a StartDate field and
EndDate field and Table2 has a Date field and Price field,
I want to show prices from different rows (StartPrice from
one row and EndPrice from another) in Table2 for every row
in Table1. Is this possible?

 

[Nikos Yannacopoulos]

If I understand correctly what you are saying, yes, it is possible; what you
need to do in query design is add Table2 twice, then join Table1 to the two
copies of Table2 as required.

HTH,
Nikos