Product Details in Opportunity

[Guest]

I have established links between BCM and an Access database. I want to
capture the Product details in the Opportunity. However, the Opportunities
table does not contain this information. How can I obtain the product
details associated with the Opportunity?

Thank you.
Bernie

 

[Luther]

There's a table called something like OpportunityProducts. Each record
will have a foreign key to an opportunity in the opportunities table.

 

[Guest]

Do you know where this table can be found? If I use Linked Table Manager and
select Files As Type as "Outlook" or "Exchange", the products table does not
appear. Is it stored elsewhere?

Thank you,
Bernie