Creating a Call Log for Customers

[qtadams]

I need to make a DBA that will have 2 tables. One Has general Infomation name, address, phone, ect. Another that will log each call made to that customer. The purpose is to log everytime I speak to a customer and be able to determine using a qury who I have not called in a while.

[NTC]

And the question is ?? ....... Your Customer General table must have a unique ID per unique customer....generally the autonumber field type will suffice for that....and be the key field...

Then in the Log table - you need to have that Customer ID field - for cross referencing purposes...If the customer ID is autonumber then this field is a number field....

Then to implement for data entry/viewing ....you make the Customer table into the Main form - - and the Log table into the sub form.

Hope this helps

[qtadams]

Thank you very much. I always get tripped up with the relationships. How do I create the correct relationship?

[NTC]

correct them? .... well there is a Show Relationships in the ribbon Tools - and if you have set them up incorrectly then you put your curson on the connecting line, right click, and delete that line...

but in general - - when you set up the sub form - the wizard is going to step you thru asking what is the cross ref key - it is actually going to suggest the key - and that's all one needs to do.....