Crystal reports query

[bwalton]

Hi

I am creating some new reports to assist our admin of actinic and would like to produce a stock list of products with there associated components (if any), creating a stock report is straight forward but I am struggling to identify the table where component information is stored and beginning to think that maybe it is created on the fly without the data been held in another table (other than product) can anyone assist?

Regards
Brian :confused:

[Jan]

The property information is stored in the productProperties table, the link between products and this table is the product reference. The productProperties table holds all sorts of information and the nType field determines which type of information you are dealing with.

Regards,

[bwalton]

Thanks Jan

will investigate

Regards
Brian

[bwalton]

Just to Say, worked a treat

Thanks

Jan