Jump to content
Sign in to follow this  
RyanN

Database General Question

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
RyanN

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Robert Schaub

[ QUOTE ]

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

 

[/ QUOTE ]

Right

 

Strengths

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  



×
×
  • Create New...

Important Information

Terms of Use