dbTalk Databases Forums  

What Tables in fm8?

comp.databases.filemaker comp.databases.filemaker


Discuss What Tables in fm8? in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
leehunt1@cox.net
 
Posts: n/a

Default What Tables in fm8? - 12-07-2005 , 03:24 PM






I am new and trying to determine what tables to create for this
problem.

There is a list of people in Group A. And a different list of people in
Group B.

One person in Group A will me matched with one or more people in Group
B.

Each person in Group A will make a periodic donation to person in Group
B.

What tables do I set up to keep track of who donated to whom and how
much?


Reply With Quote
  #2  
Old   
42
 
Posts: n/a

Default Re: What Tables in fm8? - 12-07-2005 , 04:50 PM






In article <1133990680.293631.66050 (AT) o13g2000cwo (DOT) googlegroups.com>,
leehunt1 (AT) cox (DOT) net says...
Quote:
I am new and trying to determine what tables to create for this
problem.

There is a list of people in Group A. And a different list of people in
Group B.

One person in Group A will me matched with one or more people in Group
B.

Each person in Group A will make a periodic donation to person in Group
B.

What tables do I set up to keep track of who donated to whom and how
much?


Essentially - in its simplest form:

People : {first name, last name, pid}
That tracks the people, all of them.

WillDonate : {pidDonater, pidDonatee, amount}
That will track will donate & how much to whom, for the next period.

You might also want a log:

DonationLog: {pidDonater, pidDonatee, amount, date_donated}
That will track who has donated what to whom.

-----

Obviously you'll need more or less detail depending on exactly how your
donation system works, but that should get you started.

-cheers,
Dave


Reply With Quote
  #3  
Old   
leehunt1@cox.net
 
Posts: n/a

Default Re: What Tables in fm8? - 12-07-2005 , 06:12 PM



Thanks, Dave. This was the general direction I was going after a few
false starts. You have given more confidence.

Lee


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.