LOOKUP WIZARD, is it possible?

finneyz

Registered User.
Local time
Today, 09:31
Joined
Dec 27, 2012
Messages
51
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
 
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?
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom