Lookup, Select ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

does anyone know how i can create a function to select a primary keyID in a
table that cross references or "look up" an item in a deferent column and
returns the primary key value in my form
 
It would be a straight dlookup function - the actual syntax of which would
depend upon where you were trying to do this. Having said that, if you are
doing something like trying to find an ID for the surname of Smith then
you're potentially going to have multiple corresponding IDs. The process
that is coming up with the item to look up should really be coming back a
unique (generally the PK) value. Any reason why it isn't?
 
Back
Top