Need help pleeeeease with form

[Eric1066]

Hi guys,

I have two tables A & b

TABLE A
ClientID (primary Key)
Firstname
Surname



TABLE B
CallID (primary key)
ClientID (related to ClientID in Table A)
DateofCall
CallDetails

I have a form for Table A which is only the fields in Table A

I would like a form for Table B to enter the details for it...

BUT, I would like once the client ID has been keyed for the form to display
the firstname and surname of the client that the clientID refers to in Table A
to ensure that the details entered are for the right client.

Greatly appreciated!!

[CGM3]

Try using this query for the form's Record Source:

SELECT B.CallID, B.ClientID, B.DateofCall, B.CallDetails, A.FirstName, A.Surname FROM B LEFT JOIN A
ON B.ClientID = A.ClientID

The LEFT JOIN means it will include all of the records from Table B, even if no ClientID has been entered.

[Eric1066]

Thanks for the response, but I have no Idea what this means where do I put 'left join'

Thanks for your help
Eric

[NTC]

well - what you really want to do is to have the two forms together...make one of the forms to be the subform of the other form - - the wizard will step you thru it...then you will always be sure you are in the correct record....