Re: Ralationships!

#1

In reply to d7VXa.235548$o86.139891 (AT) news1 (DOT) central.cox.net on 8/5/03 2:14 PM
by Spam (AT) markris (DOT) com Spam (AT) markris (DOT) com:

Stab in the dark.

Check to see if the Fields in the relationship are of the same type. (i.e.
both are numbers, dates, text, etc., also if there is a calculation in the
relationship, that its result is the same type as the the related field).

It isn't hard to have the relationship reversed

HTH

Lee

Quote:

Hi,
Can someone explain to me that when creating Relationships that some work as
designed, and some don't ( Like they just don't see the data). I can not
seem to find out what the problem is, some records get all the data from the
secondary file, some get portions of the data, and some get NO data at all.
. . . .

I would appreciate some to get me going to search the problem, for I don't
have a clue.

FYI Using FileMaker Pro 6.2 - PC Windows 2000 Operating System only.

Thank You
Charlie

#2

Another stab in the dark:

Sometimes when I'm placing fields in a portal, I accidentally designate
fields through relationships other than the one assigned to the portal.
On the layout, it all looks fine and dandy, but then the values showing up
in the portal are wrong. When I have made that mistake, it has given me
results similar to what you describe.

In article <BB556E06.2C6C8%lee (AT) pacific (DOT) net>, Lee Smith <lee (AT) pacific (DOT) net> wrote:

Quote:

In reply to d7VXa.235548$o86.139891 (AT) news1 (DOT) central.cox.net on 8/5/03 2:14 PM
by Spam (AT) markris (DOT) com Spam (AT) markris (DOT) com:

Stab in the dark.

Check to see if the Fields in the relationship are of the same type. (i.e.
both are numbers, dates, text, etc., also if there is a calculation in the
relationship, that its result is the same type as the the related field).

It isn't hard to have the relationship reversed

HTH

Lee

Hi,
Can someone explain to me that when creating Relationships that some work as
designed, and some don't ( Like they just don't see the data). I can not
seem to find out what the problem is, some records get all the data from the
secondary file, some get portions of the data, and some get NO data at all.
. . . .

I would appreciate some to get me going to search the problem, for I don't
have a clue.

FYI Using FileMaker Pro 6.2 - PC Windows 2000 Operating System only.

Thank You
Charlie

--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Ralationships!

comp.databases.filemaker comp.databases.filemaker

Re: Ralationships! - 08-05-2003 , 04:21 PM

Re: Ralationships! - 08-05-2003 , 05:02 PM