Are you trying to accomplish something like this (for a many-to-many relationship)?

Sample file is Access 97.