Jump to content
The site is updated on a beta version. Maintenance tasks are running so search and index may not function at this time. ×

aoutofill a price in a sales record portal???

This topic is 5908 days old. Please don't post here. Open a new topic instead.

Recommended Posts


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 !



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.



Link to post
Share on other sites

This topic is 5908 days old. Please don't post here. Open a new topic instead.

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.

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.

  • Create New...

Important Information

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