What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MS Access question: Lookups

MS Access question: Lookups
Author: Message:
brian
Senior Member
****

Avatar

Posts: 819
Reputation: 43
– / Male / –
Joined: Sep 2004
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.
02-22-2006 08:20 PM
Profile PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
MS Access question: Lookups - by segosa on 02-22-2006 at 07:36 PM
RE: MS Access question: Lookups - by brian on 02-22-2006 at 08:20 PM
RE: MS Access question: Lookups - by segosa on 02-22-2006 at 09:42 PM
RE: MS Access question: Lookups - by TReKiE on 02-24-2006 at 10:03 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On