Hi.

Table A:

"Field1" Character Unique

"Field2" Numeric not unique

etc...

TableB:

"Field1" Character Not unique

"Field2" Numeric Not unique

etc...

Naturally the two fields in table A together form a unique key.

The two fields in TableB together form a unique key.

I wish to create a view where using the two fields in table A the required row is read off table B.

TableB has a whole set of identical "Field1" rows and the value of "Field2" indicates which row is required.

This is a general principle and maybe Creator can't do it. I hope it can.

I got it to work in Caspio quite easily(I am not clever) but can't get it to work in Access.

Please tell me if I am on the right track.