Jump to content
Sign in to follow this  
thollowood

Just a stupid contact log

Recommended Posts

My brain is ready to explode. I have a datbase for case management, and I want each client record to have a contact log. I have created a table "contact" which contains these fields: Date, Notes, Type of Contact, clientid_pk. I have linked my clientid_pk to the contact_fk serial numbers under relationships. I want to be able to go from my main client layout to my contact layout, where I can enter and review dated notes for just that client. I have no clue what I am missing - I've tried several things and just can't think this one through. Any advice would be a tremendous help to my sanity.

Share this post


Link to post
Share on other sites

Well sounds like you hvae 2 choices.

1) Place a portal that displays the child records in the parent record file using the relationship you have set up.

2) Use a GTRR(Go To Related Records) script to go straight to the Child records so you can view them there.

Let me know if you need more details.

Michael

Share this post


Link to post
Share on other sites

I have created a table "contact" which contains these fields: Date, Notes, Type of Contact, clientid_pk.

I have linked my clientid_pk to the contact_fk serial numbers under relationships. I want to be able to go from my main client layout to my contact layout, where I can enter and review dated notes for just that client.

I understand that your relationship is this:

Client::clientid_pk = Contacts::contact_fk

Is this a self relationship or do you have two separate tables in this scenerio?

If you want to keep all the data in the same table, you could have fields designed just for inputting data, and then move that data to a single history field and make sure it is formatted and date/time stamped.

Otherwise I would suggest that you have a new table to contain your contact information. You would then make sure that the relationship is setup to allow you to create records in the Contacts table from the Clients table.

Then you could just use a portal in the clients table to view the contents of the Contacts table and you could directly add new records to the contacts via the portal.

Share this post


Link to post
Share on other sites

Ahh, I know I am missing things because I am am completely learning as I go. Client and Contacts are 2 seperate tables, and I have done the portal but I do not know how to make new records from the portal or how to scroll/view all the contact records through the portal. It asks me how many lines for the portal, but won't that make a very long page? I am trying to set the portal on a tab field, is that messing me up? Ready to send someone flowers here.... thanks, Tia

Share this post


Link to post
Share on other sites

OMG ! I figured it out. Thanks for the help, after re-reading a few times and a few tries it sunk in. PHEW. Tia

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.