Multiple Invoice To One

[donjuan1498]

I have a database in which I am importing invoices from several different companies. The data is named different on each invoice, however they all have about 5 common data rows. I need to be able to summarize and add up all of the invoices while maintaining the data that is imported.

Is there a way to create another table which will allow me to another table which brings in the 5 data rows so that I can make accurate reports?

I know this is a little bit confusing I can tell you that the companies all have an agent number and the connect to an agent database relationally.

I am fairly new to filemaker so please go easy on me.

[LaRetta]

Hi donjuan1498, welcome to FM Forums!

We need more information:

[color:blue]The data is named different on each invoice, however they all have about 5 common data rows.

Please provide what types of information is different. And what are the 5 common rows?

[color:blue]I need to be able to summarize and add up all of the invoices while maintaining the data that is imported.

What do you need to summarize? Invoices usually have:

CustomerID

CustomerName

CustomerAddress

DateCreated

InvoiceNumber

And the one usually has a LineItems table which holds the multiple items ordered:

Stock#

Description

QuantityOrdered

PriceEach

Lastly, what needs to be summarized? Do you want to group and total the same CustomerID, or quantity sold per Stock# or?

[donjuan1498]

Thanks for the response. I apologize about my vagueness on my last post. Here are some examples of what I am looking at.

I have 5 tables of invoices each with several different fields however the have about 4 fields in common.

- Agent Number

- Commission

- Sold Amount

- Transaction Date

I also have an agent table with basic information in regard to agents.

- AgentID

- Name

- Address

- Phone

etc.

This table is related to another table called Agent Numbers which has

- Table ID

- AgentID

- Agent Number

- Company

Right now I am linking the tables like this

Agents table AgentID->Agent Numbers Table AgentID

Agent Numbers Table Agent Number ->Company Invoices Agent numbers.

The problem I have is that its a 1 to many table and I am only able to bring over one company in a portal row. I want to be able to look at all the companies in a portal row.

I need to summarize the following.

- Agent

- Agent Number

- Commission

- Sold Amount

- Transaction Date

Then total commissions and sold amounts. I hope this makes sense. I have a feeling that I am making it harder than it is. Any Ideas are helpful.

[donjuan1498]

How about if I make it even more simple. I want to take a record from 4 different table and have them populate a record in another table. Is that possible?