LOOKUP WIZARD, is it possible?

[finsmith]

I am doing a lookup wizard for a table. I was wondering if it is possible, I know its possible in a form but again trying in a table.


I have a parts table
in the parts table is a field called electrical_data a number will be entered into the table aka 1
I have a electrical table.

Electrical_ID	Electrical data
1	480/60/3
2	120/60/3
3	208/60/3
4	600V

In the lookup field for the PARTS table is it possible to have it listed as such:

Dropdown field:
1 | 480/60/3
2 |120/60/3
3 | 208/60/3
4 | 600/0/0

[finsmith]

well I was able to get what I wanted it to do, but, it is not retaining the masking part of the field.
Is that possible for a lookup field?

[alansidman]

What you are doing is not a good idea. Look ups should be done in forms and not tables. Look at this link

http://access.mvps.org/access/lookupfields.htm

[finsmith]

thanks Ive changed around my tables. I saw that from a prior post!

[Missinglinq]

...Look ups should be done in forms and not tables...

And, in point of fact, all data entry should be done through Forms, with Tables never being accessed directly!

Linq ;0)>

[finsmith]

THANKS LINQ. STILL TRYING TO DO THE CONCAT FIELD IN THE QUERY. HAVING TROUBLE WITH THE MASKING AND escapes!