I work on a Mac 10.4.9 using FM 8.0.
My problem is two tables that I have related. Table " Request" and a
field "Number" and several more fields. Table "Orders" has a field
"People" and several other fields. I am trying to find the Value of
"Orders: People" in "Request: Number" and display several of the fields
in Orders - to make up a reciept. I have had no end of trouble. Any
suggestions.
What exactly did you try that had no end of trouble?
Some insight of your level of understanding would be nice as well.
Ursus
"Ron Lambert"
news:2008010822334716807-railman@sasktelnet...
>I work on a Mac 10.4.9 using FM 8.0.
> My problem is two tables that I have related. Table " Request" and a
> field "Number" and several more fields. Table "Orders" has a field
> "People" and several other fields. I am trying to find the Value of
> "Orders: People" in "Request: Number" and display several of the fields in
> Orders - to make up a reciept. I have had no end of trouble. Any
> suggestions.
>
In article <2008010822334716807-railman@sasktelnet>, Ron Lambert
> I work on a Mac 10.4.9 using FM 8.0.
> My problem is two tables that I have related. Table " Request" and a
> field "Number" and several more fields. Table "Orders" has a field
> "People" and several other fields. I am trying to find the Value of
> "Orders: People" in "Request: Number" and display several of the fields
> in Orders - to make up a reciept. I have had no end of trouble. Any
> suggestions.
I'm not sure I understand what you're trying to do, but it sounds like
you want to find the related Orders records for a particular record in
the Request.
If this is correct, then there are two main ways to do this:
A. Perform the Find in the Request table and then have a
button which uses the function:
Go To Related Record [Show only related records]
You can then Find "Fred Flinstone" in the Request table,
click on the button and be shwon all the Orders records
that are for "Fred Flintstone".
B. Add the Related field "People" to a Layout in the
Request table. You can then perform the Find using this
field ... BUT you have to be very specific. Simply
finding "Fred" would include records for "Fred Flintstone",
"Fred Anderson", "Frederick Egglebert", etc.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)