lookup wizard between 2 seperate fields in 2 tables

[Amir]

I have a table which contains details regarding sports groups details (group
no., name, manager, location, foundation date etc.)

Another table is keeping details about games occurred between a certain pair
of groups.
There are fields called host and guest, which contains info regarding the
host & guest group of each game.

I wish to use the lookup wizard, in order to select a certain group from the
groups table (and make sure it's exist)

Its problematical, since 2 separate fields, get their data from the same
source field in another table.

How can I overcome this problem?

Thanks,
Amir.

 

[Duane Hookom]

Using lookup fields in tables is generally considered a problem
http://www.mvps.org/access/lookupfields.htm.

You can easily create a form based on your table/query that has two combo
boxes with the same Row Source.