Jump to content
Sign in to follow this  
tug

solutions wanted History

Recommended Posts

i Have designed a database for a friend who runs a small computer shop, it is for him to use to enter customer names adresses and the fault, solution, parts and price. he wants a box or button that will allow him to see if that customer has been in before and their previous faults. i have found a medical template the uses this but it is loocked so i can not see how it is done. any help would be gratefully appreciated

Share this post


Link to post
Share on other sites

Can you set up one of the fields (perhaps phone number) as to not allow duplicates?

That way, if the user enters a phone number that is already in there, it will beep at the user and provide a clue that this customer already exists.

And if the customer already exists, you can do a portal for all their transactions.

BTW- do you have a structure of the database? The clients should be in a separate table from their transactions.

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  

  • Similar Content

    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
  • Who Viewed the Topic

    1 member has viewed this topic:
    MikeKD 
×
×
  • Create New...

Important Information

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