telephone log

S

Steve

Start with these tables:

TblCallee
CalleeID
FirstName
LastName
PhoneNumber

TblPhoneCall
PhoneCallID
DateCalled
CalleeID
SubjectOfCall

Steve
(e-mail address removed)
 
E

ErikFM via AccessMonster.com

Steve's list is a good one.

After you make the two tables, go to Database Tools and define a one-to-many
relationship between the CalleeID of the TblCallee table and the CalleeID of
the TblPhoneCall table.

Then have Access create a form for you (just highlight the TblCallee table
and choose Create, then Form).

Hopefully Access will set up the Subform automatically. If it doesn't, put in
a Subform (under Design). Have the source data for the Subform be the
TblPhoneCall table where the CalleeID is equal.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top