Call Log Populating a Table

[label027]

Hey all, I am fairly new to Access, especially 2003, so forgive me if this is a simple question (or stupid one).

I have a table (RepList) that lists all of the reps for a number of different firms. In this table I have the following field names:

Firm (which is just the code for the particular branch), Branch, LastName, FirstName, UserID, Email, Phone.

What I am trying to do is create a form for a call log so we can track who is calling and for what reason.

I have a table (Call Reason) with the records of the most common reasons people call in. I have created a table I want this form to enter the data into (CallLog) with the field names: Branch, Name, Date, Phone, Call Reason, Notes.



The problem I am having has to do with bound/unbound controls. I can easily create a form where the user can type in all the information and it populates CallLog, however I want it so there is cascading combo boxes (I already know how to do this) so you can click on the firm in a combo box, click on a rep under that firm in another combo box, and then click on one of the Call Reasons. Everything else will be bound so the user will type into the form and all of this information, hit enter, and is stored in CallLog.

I have read about how 'duplicating information in another table' is frowned upon, but I don't see any other way around this. I want a simple user interface that will allow us to quickly log a phone call so we can track which firms are constantly calling. Any thoughts?

[alansidman]

Your cascading combo boxes can be bound to the table containing all your call log information. Hence, only one table for the calls

In the properties, on the data tab, set your control source to the field in your call log table you want it bound to. In the properties, on the data tab, your Row Source should be the SQL statement for your look up table. Repeat it for all the combo boxes.

Alan

[label027]

Thanks alansidman that worked, I'm slowly learning!