José;

You must have a common field between the two tables to relate one to the other. I have many questions, such as:


1. Is this your application?
2. Can you make changes to the tables and application?
3. Relationship of supplier and material. Can there be more than one supplier for one type of material?


It seems we have to tie the Supplier with the Material Used?

If you would like to discuss this further let me know. I would like to understand more about your requirements and application to see if we can help you.

Tom



>Hi Thomas:
>
>They request a report to me that handles fabrics of a client
>
>Client
>Remission Products meters
>
>Total
>
>The products have a formula that handles necessary the raw materials for its elaboration, I must obtain the cost for these, soon by supplier remove a summary and this to present/display it in the same report
>
>Suppliers
>
>Supplier sum of cost
>
>Total
>
>As you can see they are data that do not have relation between both, for that reason I need to handle two tables to level details. Is possible?