Jump to content
Sign in to follow this  
Andy_

aoutofill a price in a sales record portal???

Recommended Posts

Hello,

I am trying to have a price looked up and automatically filled in to a sales record in a portal.

I have attached a graphic of a simplified version of what I want to do to help explain.

I basically have four tables, a list of products, a price chart, a client page and one to record all sales.

When inputting a sales record I want the price to be looked up after selecting the appropriate currency and product name from pull down menus but I have so far been unable to get this to work.

I would be very grateful if anyone could provide any example script or suggestions as to how to do this as it has been giving me a headache for some time now.

I am also not sure how to combine my table of products with the column headings in the price chart and the drop down menu in the portal.

Thanks in advance for any help !

Andy

Example.jpg

Share this post


Link to post
Share on other sites

I think that part of your problem is with the way you have structured the product file and the price file. I have taken the time to put together a simple 4 file system that accomplishes what you want. There are of course many ways to put something like this together, but I hope that the attached file will help point you in the right direction.

Echo

Sample.zip

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.