This is driving me a bit crazy so I hope someone can help me out here.

I am linking to an Oracle table which has the primary key ORG_ID.

In my Access front end, the data type for ORG_ID shows number, with field size DECIMAL.

I cannot use this table as a reference for lookup. It does not show.

I created a dummy table and updated this same field to a data type of number, field size INTEGER. This time, I could see it.

Now, what I need to do is create a reference somehow to use this ORG_ID in this INTEGER data type. I am able to use val([ORG_ID]) to get a working value, but I cannot reference this calculated field in data type lookup.

Anyone have any ideas?