> problem, I think of Robo Cop. > I'm building my first Relational DB and
> need some words of wisdom from the > Wise Ones. I've built a DB with three
> related files: Inventory, Customers, and > Orders. The demo/template on FM
> Pro 4.0 seemed to require alot of modification > to meet my requirements
> so I decided to go from scratch. > > Naturally, I ran into problems.
> Problem one is that the summary fields in the > Orders file seems to be
> cumulative over all the records in the field. They are > summaries of
> repeating fields if that matters. How do I restrict the summary > to the
> current record?
> DUHH!!! Okay I figured out that I need to be using a calculation field,
> not a summary field, so the Wise Ones can stop snickering now. Still
> pondering the second problem...
> Steve C.
> > Problem two is that I'm trying to figure out the best way to
> > automatically deduct the sell quantity in the Orders file from the
> > quantity on hand of the Inventory file. The demo version seems to have
> > an intermediate file between the orders and inventory file. I'm starting
> > to think that there is a good reason for this. Any suggestions? Advice?
Yes....that intermediate file is "LineItems" I bet...it holds the info
you are now holding captive in your Evil Repeating Fields. ;)
ReLEASE that info! Set it free and it will make you rich! RICH, I say!!!
Ahem....never mind, I got overenthusiastic. You need to redesign so
that each line item is in a database related to Orders by the Order ID.
This will allow a) correct relational design and b) great flexibility in
reports, calculations, summaries, etc. This way your Inventory
depletion will take place on ONE line item per go...no wrassling with
getting which repetition of which repeating field. You view (and can
create) the LineItems through a portal on the Order layout.
Repeating fields seem so cheap and easy when you start out....just pop
them on there and damn they add up so nice.....but try finding. Try
sorting. Try, fer goshsakes creating a report! But they're a cheat and
sham and will make you wish you'd never heard the word database before
you're done. ;)
Do it the correct way, on the other hand, and your teeth will be whiter,
your car will never rust, and life will be easy and prosperous. Really.
Allen & Allen Semiotics FSA Member - Filemaker Pro Consulting
http://www.semiotics.com Web & Graphic Design