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

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

Thank you very much Echo, this is perfect.

Andy