LOOKUP WIZARD, is it possible?

[finneyz]

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 600/0/0

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

 

[finneyz]

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?

 

[Pat Hartman]

Lookups do not belong in tables. They cause nothing but problems. You can do what you want with a combobox on a form. In the query you use for the RowSource, you can select the PK and format the display field however you want to see it.

 

[finneyz]

thanks pat. I appreciate the response. I have decided to put the data in a query, but having issues pulling the input mask.

see this link below.

 

[finneyz]

http://www.access-programmers.co.uk/forums/showthread.php?t=240699