AnsweredAssumed Answered

Automating a join table build

Question asked by WesleySantiago on Feb 18, 2015
Latest reply on Feb 18, 2015 by philmodjunk


Automating a join table build


I need to join 2 single tables, States to Cities, xJoin would be the combined location to be referenced later.

States >-----------xJoin--------<Cities

The Cities table has 40+ entries and States has only ~6 records. Is there a faster, more automated way to build up xJoin rather than manually creating a new record in xJoin and typing in the matching id numbers of States and Cities to create linkage?