Creating arbitrary relationships?

[Guest]

I have 2 lists of equal length that I want to create an arbitrary
relationship between.

i.e. if table 1 has column A and table 2 has column B (with no relationship
between the columns) then I want to create a table 3 with columns A & B
containing each column value only once. The length of table 3 should be the
same as tables 1 & 2.

I want to use an access query because the lists are too big for copy-pasting.

Ta in advance
David

 

[Guest]

Add autonumber column to both and join on them - duh!

 

[John Vinson]

I have 2 lists of equal length that I want to create an arbitrary
relationship between.

i.e. if table 1 has column A and table 2 has column B (with no relationship
between the columns) then I want to create a table 3 with columns A & B
containing each column value only once. The length of table 3 should be the
same as tables 1 & 2.

I want to use an access query because the lists are too big for copy-pasting.

Ta in advance
David

It sounds like you're thinking of these tables as if they were
spreadsheets, with row numbers; or at least with a defined record
position, with the "first record" of one table matched to the "first
record" of the second table, second to second, third to third.

No easy way to do so - an Access (or other relational table) is best
viewed as an unordered "heap" of data. It's like matching two
wheelbarrows full of potatoes, first potato matching first potato...
simply doesn't work!

All I could suggest is that you add an Autonumber field to each table,
and join 1 to 1, 2 to 2 and so on. Getting the right autonumbers with
the right records might be a challenge.

John W. Vinson[MVP]