Table Setup

[Guest]

How do you have multiple dates for multiple clients in a call log linked to a
client table?

thanks

 

[Guest]

If I'm reading this right, you would just have a second table, call it 'Call
Log', with column 'ClientID' (or whatever) as a foreign key in a many-to-one
relationship with the key of the Client table; column 'Date', and then
columns for any information needed for each call you're logging. You could
set up an AutoNumber column to create an arbitray ID for the key of this
table, or if you don't like arbitrary IDs, you could program in VB on the
data entry form something to create an ID out of the ClientID and a date+time
string.