Jump to content
Sign in to follow this  
Mike CPB

Multiple link between two tables

Recommended Posts

Seperately, one link at a time, each thing I'm trying to achieve works. But I'm hitting a brick wall when doing both.

I have two tables. Clients / Call Log.

I show a protal from Call log on a layout from clients. My portal show limited but vital information regarding past call logs.

In the same layout I have linked fields from the the call log table. A script that creates a new call log and captures the call log record id and the linked fields are now active.

Each aspect by itself works fine. But when I create the relationship for both it limits the portal to that new call log record, which makes perfect sence to me.

I'm either going to have to redesing and make temporary fields that script and paste into a new call log, which is my plan as of this moment.

I was just wondering if there was a trick to make the magic happen.

Regards, Mike.

Share this post


Link to post
Share on other sites

I'm trying to picture what you've described.

On a Client form you have a portal to Call Log table related by ClientID.

You have a button "New Call" that creates a new Call Log record, populating the foreign ClientID.

You set the new CallLogID to a global field in Client. Then, using a relationship from Clients to Call Log by ClientID AND gCallLogID, you have placed fields on the Client form that you'd like your user to edit (they're text fields that are long and aren't easily edited in the portal).

Is this your scenario?

Share this post


Link to post
Share on other sites

Yes pretty much but not "(they're text fields that are long and aren't easily edited in the portal)"

I'd like to see client information, edit the new call log and view previous call's.

Regards, Mike.

Share this post


Link to post
Share on other sites

I'm still very new to filemaker pro. But It seems that in the relationship graph by duplicating the call log table and creating separate links, like I had individually working, on one for each of the two tables to the client table, it looks like its working.

If this is a fluke I wish to be corrected. If this is the way it was meant to be setup then I'm happy I've stumbled upon it.

The client RecordID is copied and pasted on each call log ClientRecordID. This is what I’ve created to relationship the portal.

During a new call log, that call log RecrodID is created and temporarily copied during a call to the client CallRecordID. This relationship allows user editing of that record. Then when the call is closed it is cleaned.

If this could be done more correctly I might need to go to school or something to learn, but for just grab-n-go ego I have this is the best I can do.

Regards Mike.

Share this post


Link to post
Share on other sites

Perhaps you'd like to post a demo of what you've got.

Share this post


Link to post
Share on other sites

This file is just a demo with the same basic relationships and script.

My database's layout design is not as open for total editing to prevent user error.

Obviously my layout design doesn't have identical portal and linked fields like this file.

If there's a better/proper way to achieve this then I would be interested in your comments.

Regards, Mike.

Contact_Management.zip

Share this post


Link to post
Share on other sites

Have a look at this demo I posted in answer to a similar thread: Note Demo

Share this post


Link to post
Share on other sites

Thanks for you're time, I see that we the relationships are along the same path, and yes the individual link is more efficient as a global.

Regards, Mike.

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.