Basic Question for Lookups.

Just wanna be sure that after writing so many tables .oof +++ I think I'm
crazy asking this...

IMHO, I'm properly storing Prospect ID pk then FirstName then Middle then
Lastname fields.etc. for 3nf.

But when I'm doing my lookups in a Contract table or meeting table for
example and lookup say a prospect and employee and manger I'm using the
lookup wixard in my tables. When it asks on the fourth screen what to store I
select the actual say Prospect ID not the first or LastName.
But then when I view my records in form view I see only the Ids ? :even
though when in the add mode the lookup up combo box showed the three items ID
First and Last to make intlelligent choice. otherwise with no ID in the drop
downs would not be able to determine which Micheal Jackson to choose.

Problem is my client says he doesn't want to see the IDs only names... Am i
missing somethjing here or have I just not properly explained the concept to
my client..

SO final question is how to show in the view/edit mode after entering the
data all three elements( ID First and Last), Would I have to have three
diffent fields? That would defeat my 3nf foundation wouldn't i, since by
referencing the ID I could query the First and Last etc in queries reports
etc.

I hope this made some sense !

I guess it's late :-)
--

.

Relevant Pages

  • Re: Basic Question for Lookups.
    ... "Duane Hookom" wrote: ... I would suggest that you don't use lookup fields defined in tables ... I'm properly storing Prospect ID pk then FirstName then Middle then ... >> Problem is my client says he doesn't want to see the IDs only names... ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Basic Question for Lookups.
    ... The Query that I would suggest is similar to what the Lookup ... > 1801550689 Michael Zachary Jackson ... I'm properly storing Prospect ID pk then FirstName then Middle then ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Basic Question for Lookups.
    ... I would suggest that you don't use lookup fields defined in tables ... Use combo boxes on forms. ... I'm properly storing Prospect ID pk then FirstName then Middle then ...
    (microsoft.public.access.tablesdbdesign)
  • Vlookup Function
    ... the following array formula is what you're looking for (to ... >Im trying to use the vlookup function. ... >with the prospect of only having values in ... >Is there a way of having it lookup a value between A1:C1 ...
    (microsoft.public.excel.worksheet.functions)
  • Vlookup Function
    ... Im trying to use the vlookup function. ... I need it to do the lookup over three rows. ... with the prospect of only having values in one row, ... Spike ...
    (microsoft.public.excel.worksheet.functions)
Loading