The MS Access website is very unhelpful on this topic, and I cannot
find anything in my Googling to find a hint.

I am working with very large, existing data sets that consist of
multiple fields. Two of the fields are "Origin" and "Destination".
These fields contain the FAA Airport Codes, so the data is similar. I
also have another table with all FAA Airport Codes, corresponding FAA
Airport Categories, and Airport Names.

I need to establish the relationship between the main air travel table
and the airport table. Both the "Origin" and "Destination" must relate
to the FAA Airport Code table. However, when I establish this
relationship and examine the FAA Airport Code table, I get the
equivalent of an "and" function. In other words, the only records in
the subtables are those flights that both originated and terminated at
the SAME airport (aka "sightseeing" flights...) What I need is the
records of ALL flights that EITHER originated OR terminated at the
specified Airport.

All the Microshaft website says is "don't do that".
I am a novice, and any clue would be helpful.

TIA

If I understand your application correctly, you need to link to two
separate instances of the codes table. In your query, add a separate
instance of that table. Then link the travel table to the first
instance by the origin code, and to the second one by the destination
code. Then you can create an OR filter using the fields from the two
copies of the codes table.

"PPT33R" <mtmueller (AT) usa (DOT) com> wrote in
news:1104871077.335483.133000 (AT) z14g2000cwz (DOT) googlegroups.com:

the query builder, try this.

open a new query in design mode. Add the travel table. Add the
airport table twice. Link the link between the Origin field to
one of the two airport tables. Link the Destination field to the
other airoport table.


--
Bob Quintal

PA is y I've altered my email address.