RE: MS Access question: Lookups
Either go the wrong easy but not smart was is requerying the server to find out the {customerid} of {firstname lastname}
Not sure what language you want to do it in though, but you could create an array, like $array[0][customerid] $array[0][firstname] and look up what $array[X] has firstname = $array[0][firstname] then grab the customerid.
What I once did that worked with a JS control is, I had a datatable with 5 columns and X rows. I say X rows because it depended on how much data I retrived, because the system worked in a way I had to give an array to it so it would create the datatable. I gave an array but each column has 6 columns, not 5 (6th being the ID). It didn't show the 6th because it was supposed to be 5 columns, then when I needed the ID, I just used the same array and went to the 6th record. -- This depends on the language though.
|