"client last name" & client table "last name" same info-join?how

[Access problems]

Access job table has "client last name" & client table has "last name". same
data different name. when i try to join relationship nothing happens with
the data. it is not sharing data for last name.???

 

[Jeff Boyce]

Are you sure you want to do that?

How many "Smith" or "Jones" or "Fernandes" or "Ivanov" entries might there
be in a job or a client table? Joining on "last name" is not a good idea...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Al Campagna]

Your Job table should be related to your Client table by a unique
key field, like an autonumber... not a LastName. What happens when
you have more than one Smith in your database? LastName is not unique
enough to create a realtionship.
Not sure what that means, but correcting the table structure and key
fields would trump that issue...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."