Database General Question

[RyanN]

Does anyone know of a Database out there for Filemaker that I could purchase or download free on Manufacturing Estimating. Something for devolping cycle times for processes, I looked at B2B but not sure if that is what I need. I need to build a Bill of materails and than be able to add work centers for manufacturing process, welding, saw cutting, Drilling, tapping ect. Any help would be great

 

Thanks

[Pes]

Not that hard to do in FileMaker.

 

Two things to keep in mind:

 

1.follow the normalization rules, at least to the 3th

 

2.your relationship diagram has to be made in accordance with the ‘modified preorder tree traversal algorithm’ to avoid problems in the long run.

 

You can work with an ‘adjacency list’, but when you want to add layers, chances are you will hit a wall.

 

Make your 'homework' first on paper and FileMaker will follow...

 

HTH

[Ted S]

Ryan,

 

I am not aware of any pre-built solutions for heavy manufacturing. By heavy I mean bills that go 10+ levels deep, have thousands of purchased components and scores of assemblies.

 

Building your own solution is a possibility if you product structure is simple.

 

Just curious; how deep do your bills go? How many levels? How many purchased items? How many assemblies?

[RyanN]

Most Part As. are under 20 parts. Basicaly I want to start building a Estimating package tailered to what I do. Over the years I hav emade costing estimate work sheets in Excel. Always dreamed of building one in a database format. I am new to FM and this is probaly a very large task to attack, but nothing ventured, nothing gained.

[RyanN]

Spelling isnt one of my stengths....;0)_

[Inky Phil]

Ryan

I did the same for my business starting with nil knowledge of FM but a very basic knowledge of db's.

 

It can be very frustrating at first but is well within your scope if you have done it in excel. This demonstrates that you understand the processes that you want to automate and with the wonderful help that is available through the forums such as this you will find it a very rewarding experience. I know that I did.

 

I say go for it.

 

Good Luck and don't be afraid to ask

 

Phil

[Guest Yukon Cornelous]

Have you looked at

 

Enterprise Automation System ?

[Robert Schaub]

[ QUOTE ]

Spelling isnt one of my stengths....;0)_

 

[/ QUOTE ]

Right

 

Strengths

[RyanN]

Thank you for the support, One thing is true Filemaker 7 is addictive and alot of fun. Yes I did look at B2B seems like a real good database starter, but at $400.00 that is steap. I dont know maybe that is a deal. There is alot to learn here in this forum, I am thankful for all the kind people in here.

[harryglos]

Hi Ryan,

 

Did you look on the FileMaker forum under,

 

http://www.filemaker.com/developers/

 

You may find something there. I've got a solution nagging at my brain, ha, that could be just what you're looking for but I just can't seem to put my finger on it. I'll get back to you after I have the great epiphany.

 

RE: Spelling isnt one of my stengths....;0)_

 

I don't remember who said it but they are true words for sure. "It is a poor mind indeed, that can only think of one way to spell a word"..

 

Harry