Using FileMaker Pro 5.5: through a [sALES DETAIL] file using a [LINE ITEMS] file pulling data from a [PRODUCTS] file.

We all know the old story of

I think you need to hire a consultant. This is pretty far beyond a quickly answered question for a forum. Take a look at www.co-media.com/filemaker/index.html for the FSA directory. In the words of Clint Eastwood "a man's got to know his limitations".

-bd

[ April 17, 2002, 11:14 AM: Message edited by: LiveOak ]

There is an FSA Partner in Miami and he can help you. [mailto:[email protected]}

Old Advance Man

Now I'm not 'chickening out', but I really think we need to hear from Bob Weaver on this one. This must surely be just the kind of emergency he keeps his feathers numbered for.....

I don't know Bob, but what's up with the "feathers numbered"? He can only be the ultimate Guru... Go feathers!

If you're still interested I can give you ERDs.

Dj

There's a demo of an invoicing system with quantity price breaks here:

http://www.dwdataconcepts.com/dwdctips.htm

The basic technique is to have not only a products file, but link it to a prices file which contains the price breaks. Then your invoice can do a lookup, where no exact match copies the next lowest value.

All of the things you want to do are do-able in FileMaker, but it's a big project. Just take it a step at a time... and ask for a raise.