dbTalk Databases Forums  

Basic Design

comp.databases.filemaker comp.databases.filemaker


Discuss Basic Design in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
roadworthy@gmail.com
 
Posts: n/a

Default Basic Design - 04-11-2007 , 10:22 PM






I'm working on my first FM database (v8.5), & have a basic
question on how to best structure it.
I've set up two tables. The first (Main) has approx. 40 records
corresponding to the contracts I manage. The second table (Contacts)
will have about 30 records, as some contracts share a common contacts
record. I've designed a Layout using the Main table, which in Form
View, shows me one record. I'd like to be able hit a button on this
layout which will jump to the related Contacts record. Should I use a
tab control? Do I need to define a relationship between the two
tables?


Reply With Quote
  #2  
Old   
Christoph Kaufmann
 
Posts: n/a

Default Re: Basic Design - 04-12-2007 , 12:56 AM






<roadworthy (AT) gmail (DOT) com> wrote:

Quote:
I've set up two tables. The first (Main) has approx. 40 records
corresponding to the contracts I manage. The second table (Contacts)
will have about 30 records, as some contracts share a common contacts
record. I've designed a Layout using the Main table, which in Form
View, shows me one record.

I'd like to be able hit a button on this
layout which will jump to the related Contacts record.
Go to layout mode, choose the buttom tool from the status bar and put it
on your layout. Attach the step "go to related record" to that buttom.

Quote:
Do I need to define a relationship between the two
tables?
Absolutely.
--
http://clk.ch


Reply With Quote
  #3  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Basic Design - 04-12-2007 , 01:32 AM



In article <1hwg600.12co6se1ta3zw8N%clk (AT) freesurf (DOT) ch>, clk (AT) freesurf (DOT) ch
(Christoph Kaufmann) wrote:

Quote:
roadworthy (AT) gmail (DOT) com> wrote:

I've set up two tables. The first (Main) has approx. 40 records
corresponding to the contracts I manage. The second table (Contacts)
will have about 30 records, as some contracts share a common contacts
record. I've designed a Layout using the Main table, which in Form
View, shows me one record.

I'd like to be able hit a button on this
layout which will jump to the related Contacts record.

Go to layout mode, choose the buttom tool from the status bar and put it
on your layout. Attach the step "go to related record" to that buttom.

Do I need to define a relationship between the two tables?

Absolutely.
Technically you don't "need" a Relationship, but it does make things
MUCH MUCH easier. )


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


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.