Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6835 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted (edited)

Hello,

I have recently downloaded the trial of FM8 to try and setup my company sales database.

I say New, last time I did a database it was on Dbase4 in the late 90's. :

Brief explination of database plan.

To contain the information from a customer placing an enquiry all the way through to order, utilising the same information, such as our product information (which can be pulled up from predefined fields, or typed in manually), also to contain all of the customer information etc that can be used to lookup in the orders.

And to obviously track order progress, and see charts etc on the company growth.... blah blah

I have tried to learn the basics of the software using the FM 8 Bible that I purchased, it has helped me to an extent, it does get a little advanced.

Another thing I have tried to used the teach myself is the (BPS) Business Productivity Solution provided by FM on their website, with which has totally confused me now LOL!

So on with the questions......

Firstly using the BPS

I have noticed it uses a "One record" field and contains a calculation = 1 in all of the tables, whats this used for? Do I even need to worry about it....

I am a little slow at learning relationships, is there anywhere on the web I can learn more, Im just confused on Primary keys and foregin keys, and where to use them?

I have more questions.....but I feel I need to try and find them out after these...

Any help would be much appreciated...

BTW excellent site....

Pete

Edited by Guest
Posted

Take a look at this post for places to go. I was in your shoes 6 months ago and found all of these sites very helpful.

http://fmforums.com/forum/showtopic.php?tid/176370/post/204093/hl//#204093

HTH

Al

This topic is 6835 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.