Jump to content
Sign in to follow this  
lossielab

relationships and lookups PLEASE HELP!!

Recommended Posts

I'm trying to set up a system where I can type in a client name and their address from the client address/phone number database will pop up into an ordering service. I've already linked them, and did an "auto-fill" with the lookup to the former database, but nothing seems to work.

Thank you for your help!

- mL

Share this post


Link to post
Share on other sites

We'll need a bit more information, like how the addresses are stored, and what the relationships are between the tables.

Share this post


Link to post
Share on other sites

Best way is to create an Account Number field in both databases (or tables), set up a relationship based on that, then set the address, etc. fields to be autofill by lookup.

Type in the account number, other fields fill in when you tab out of the acct # field. Can work with name field as the key field for the relationship, but the text must be entered EXACTLY for it to work.

Hope this helps!

Share this post


Link to post
Share on other sites

SoCalMacDude,

Thanks for posting this... your solution solved a similar issue that I had in common with the original poster. This raises a problem though... what happens if you don't happen to know the account ID (or in my case, the client id) off the top of your head (particularly if you have plenty of account ids/clients ids). Curious, how would you go about finding out what the account ID is

and transferring said info back to the ordering service DB?

I have some thoughts but I was wondering what you and some of the other FM proficient forum participants methodology might be.

TIA.

Jack

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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