Help with relational database

[Kimmie]

Hi All,

I have a database with 3 tables, contact, sales, and alt sales. I have a separate database for pricing. I have to send a check out depending on our sales collected. It can be up to 4 checks per month. I am trying to create either another database or table to tie into the sales to do this but not having any luck. I have the data broken down by month and want to be able to show the check sent in relation to the sale. Any help would be appreciated.

Thank you!

[Søren Dyhr]

Why two tables for sales, in my humble opinion must these have quite a few attributes in common???

--sd

[Kimmie]

Hi,

No actually they are very different. My main sales are advertisers for certain monthly issues and the alt sales are for a multitude of items, some are sold by the day for the day only so its a bit more specific. All of my entries are in portals in the main contact database.

[Søren Dyhr]

List the fields, for each table!

--sd

[Kimmie]

Hi Soren,

There are too many to list here. Is there something specific you are trying to see?

[Søren Dyhr]

Yes redunandancy and several fields having the same name just postfixed, I'm only asking for the two sales tables... but basicly must a invoicing solution be build this way:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

...which shouldn't be too tough a task to make a list of!

--sd

[Kimmie]

Hi Soren,

I emailed you the PDF's of the fields. Let me know. Thanks!

[Søren Dyhr]

Well quite a handfull, but indeed something which needs to broken up, but the existence of relationships ties doesn't make it a relational approached solution, but is this considered to be the mission??

I have the data broken down by month and want to be able to show the check sent in relation to the sale. Any help would be appreciated.

Perhaps isn't it too far from this:

http://www.fmforums.com/forum/attachment.php?attid/12512/

Except that issued checks should be the word substituting Expenses, now the solution I've directed you to havn't got invoice itemlines yet ... but as I see it, are these two solutions exhibiting familiarities!

It's BTW from this thread:

http://fmforums.com/forum/showtopic.php?tid/191659/post/273828/#273828

--sd

[Søren Dyhr]

Ok I've poked into your print sales, and here would your approach benefit from knowing this technique:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

...this is what have encountered until now where I haven't attempted to break your data up slightly more normalized. As you might notice have I been preoccupied with the thread I linked to in my previous post here.

--sd