Thanks for your post Carolyn,

I will give your solution a go, you are right it does give me more control over the data needed.

Regards  Ian

Thanks for your help on this one.

I know you are asking yourself why not do a lookup on the ERP database tables when needed, well one of the spec's required was that if the...

Hi Khoo,

I gather from what your examples shows that spliting the data into 4 tables does not help the speed issue.

Should I put the data in a single table?

Should I...

Hi All,

Thank you for you valued input.

I did not explain why I have split the data into four tables.

Project Scope: The Company’s products are sold by weight and...

Thanks for the quick replys

I have not used views before, but I will have a go.

Cheers Ian.