Auto Populate

[staines]

What I’m trying to achieve is a database that I can enter the number of calls a salespersons makes in a day. Please find diagram below.

<< Date >>

,,,,,,,,,,,,,,,,,,No-Calls
Name
Ben,,,,,,,,,,,,,,,1
Bob,,,,,,,,,,,,,,,2
John,,,,,,,,,,,,,,3


I have kind of got one working but when I create a new day I have to type in all the names every time and it get a bit boring. Can anyone point me in the direction of how to auto populate the names of salespersons when I ad a new date ?.

I have attached a quick mock-up of what I have got so far so if I haven’t explained myself very well hopefully you can see what I’m gibbering about.

Any help would be much appreciated.

Thanks, Mary

 

[Dave Eyley]

First off, I wouldn't have your tables designed like that...

Have a table with the Salesmens names and a unique ID (Primary key).
Then have the second table with date, SalesmanID, Calls etc...

Link the 2 tables using the SalesmanID.

On the form have a date input textbox, combo for the names to be selected from, and then the number of calls.

This will save you from entering the names at each session...

HTH

Dave Eyley