Entering data in forms with lookup tables

[gretsch]

Hi all,

I have created lookup tables for all comms information for clients and contacts in my db. I am now having issues understanding how to enter data in a form using this structure. I'm thinking I want a combobox showing types of comm, and then a control next to it where I can enter the info.

The structure is as follows:

tblComms
Comm_ID
Client_ID (fk)
Method_ID (fk)
Contact_ID (fk)
CommInfo
CommNotes

tblCommMethods
Method_ID
MethodName (Landline, Cellphone, email, ...)

So for instance, to enter contact info for a Client, what do I put in the frmClient_Details form? My relationship view is attached (with many recently added lookup tables hidden, spot all the ID fields). I'm not confident that I've got my left and right sides correct for the links.

I've managed to get "normal" lookup tables working in forms, but the intermediate table (tblComms) is confusing me. Help?

Thanks,
Andy

 

[YNWA]

I do not think you need so many FK's.

Link the table to either Client or contact. I would say ClientID to ClientID. So deleted contactID out of the Comms table. Your methodID is just a field for storing the selection from your Method dropdown menu that you would create.

As a client can have many contacts and many comms?

You will need to create a tabbed form and use subforms. Each linking view child and master ID's of ChildID. This will make your contacts link to your client and so on.

You can not put 3 tables worth of fields on 1 form and expect it to run right.

I am not as experienced as others, so maybe wait a bit before acting on my advice.

 

[lcook1974]

could you post a sample DB?

Welcome to the forum!!! this is an awesome place....