dbTalk Databases Forums  

one to many relationship issues

comp.databases.filemaker comp.databases.filemaker


Discuss one to many relationship issues in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jackie
 
Posts: n/a

Default one to many relationship issues - 01-02-2007 , 02:56 PM






I'll try to make this as clear as possible, as I've been reading
through past responses, but I can't really find a viable solution (i.e.
http://groups.google.com/group/comp.... f62e5d97c41b)

Basically, there's two files related by a one to many relationship
using the Parent ID. There will never be more than 4 children to every
parent, so I'm trying to find a way in which I can choose to view a
specific ONE of the children while I'm in a layout of the child file
(Not in a portal). As in, if I am on the third related file, a simple
button to view the second. As of now, I have created 3 instances of the
original child file and they are related with an equal ParentID and a
Date that is greater than it's predecessor. I have a field that
calculates the number of related IDs so I can easily find out the total
number of related files, however, in order to go to a specific one,
problems are being caused.

If the only plausible answer is using a portal, I guess I'll do that, I
was just wondering if anyone had any other suggestions. Hope this is
clear?

Thanks!
-jackie


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

Default Re: one to many relationship issues - 01-02-2007 , 03:29 PM






In article <1167771402.627922.62180 (AT) i12g2000cwa (DOT) googlegroups.com>,
"jackie" <justjacks (AT) gmail (DOT) com> wrote:

Quote:
I'll try to make this as clear as possible, as I've been reading
through past responses, but I can't really find a viable solution (i.e.
http://groups.google.com/group/comp....hread/thread/1
2f722a1a72b9ab6/0fb1f62e5d97c41b?lnk=gst&q=one+to+many&rnum=3#0fb1 f62e5d97c41b
)

Basically, there's two files related by a one to many relationship
using the Parent ID. There will never be more than 4 children to every
parent, so I'm trying to find a way in which I can choose to view a
specific ONE of the children while I'm in a layout of the child file
(Not in a portal). As in, if I am on the third related file, a simple
button to view the second. As of now, I have created 3 instances of the
original child file and they are related with an equal ParentID and a
Date that is greater than it's predecessor. I have a field that
calculates the number of related IDs so I can easily find out the total
number of related files, however, in order to go to a specific one,
problems are being caused.

If the only plausible answer is using a portal, I guess I'll do that, I
was just wondering if anyone had any other suggestions. Hope this is
clear?

Thanks!
-jackie
Do a Find in a layout of the Child table for the appropriate Parent ID.
The found set will be all the children of that parent. Then just browse
through them.

You can script this.

Also, in a layout of the Parent table, you can put a pushbutton to Go To
Related records, Child, appropriate layout, show only related records to
the current record. That will also produce a found set of the children
of that parent.

--
For email, change <fake> to <earthlink>
Bill Collins


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.