Hi,

I created a the same kind of nested form as Richard shows, The main form is a form for Suppliers the second form is a list of products & the third form is a list of the prices for the specific product as of a certain date.
I'm trying to create a form that would compare a specific product across all the suppliers to be able to see who would come out the cheapest to order from,
I have two issues with i:
First each product has a different id to it.
Second the comparing form would need to look like an excel spreadsheet so that I should be able to see the price from all the vendors.

If anyone can help or knows of a solution I would really appreciate if they post an answer.

Many thanks,
Yonatan