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 omnia
      I am a canadian and I work with fmpAdvanced.
      if you find a solution, I'd appreciate you contacting me.
      <reply by private topic>
      I am looking at a solution for inventory.  One important request is that they need to be able to calculate the inventory for previous dates.  E.g. the beginning of the quarter compared to today or this day last year.
      My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file.  Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. 
      Will this be a fast way to calculate or slow?  I don't want to start and then find things slow down on me too much.
      After this I will also need to be able to age the stock.  
    • 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.   
×
×
  • Create New...

Important Information

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