Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Silly Questions from a Newbie


buggeyes1
 Share

Recommended Posts

Hey Everyone,

I have filemaker pro 10 and this is what im trying to do.

we are a small contractor company and here are my current tables

employees: contains employee info

timecard: shows how many hours and job location

reciepts: materials reciepts with breakdown of which job supplies are bought for

customers: customer/job info

 

Im am trying to connect all this.

1st. when i type an employee name into the timecard, how do i get it to automatically pick up their rate & emp id# from the employees table?

2nd. i want to figure out how many hours and how much money is spent at each job and to eventually portal that info into the customers table. how do i do that?

 

I think i have the tables set up ok, im unsure of calculations & relationships.smiley-undecided

Link to comment
Share on other sites

Your question could be answered in a book; there is a lot to it.

 

Let me try to start you down a path..... RDBMS 101 as it were.

 

Each table should have one field that is a primary key - a unique, serialized identifier. Users never need to see this field. You can set this up as an auto-entry serial number.

 

Every table typically needs to have a foreign key - a non-unique, non-serialized field, that relates to the primary key field in the related table.

 

In a relationship, the table with the primary key is the parent table, and the field with the relationship attached to the foreign key is the child table.

 

When you create a child record, the first thing in it, should be the foreign key field, which should be populated with the primary key content from the parent table.

 

NOW the parent table information is displayable in records based on the child.

 

-------

 

In FM, everything is based on context. This is most apparent in layouts - screen designs. Each layout is based on a table occurrence and the fields there are based on this context - and the related tables.

 

If you are just getting into this, I would suggest getting familiar with table occurrences. They are a unique and powerful Filemaker construct that will make your life easier......

 

Read up on Table Occurrence Groups. Understanding this unique Filemaker concept will save you gadzillions of hours down the road.

 

Recommended reading - both available on the web. Ignore the version number of the second article - the concepts are still valid in FM 10.

 

FileMaker Development Methodologies

A pragmatic approach to developing complex FileMaker applications

Published on October 21, 2006 by Jonathan Stark

 

Key Concepts in FileMaker 7

Mapping New Territory

Michael Harris

Senior Partner, Cerné Systems, Inc.

Link to comment
Share on other sites

There is an excellent FREE template at http://www.fmstartingpoint.com/ which incorporates projects, contacts and even timesheets. Its a complex complete solution but you may be able to adapt a substantial amount for your purpose. It even comes with some instructional videos. Fill in some new contacts- project - expenses etc and play with it for a while. At the very least it will give you some design ideas and some scripts to use. It may even save you time and money to consult with the authors to alter the template to in some minor way to meet your particular application. Cheers

Link to comment
Share on other sites

Thanks for the tip for that biz template smiley-laughing.

Im in the middle of messing with it now to fit my needs, hopefully this will solve all my problems!

Link to comment
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.

 Share



×
×
  • Create New...

Important Information

Terms of Use