I'm working on my first FM database (v8.5), & have a basic question on
how to relate two tables. The first table (Grants) has approx. 40
records. The second table (Contacts) will have about 30 records, as
some grants share a common contacts record.
I've set up a button in the Grant table's form which jumps to the
related record in the Contacts table. A Grant Number field is set up
as the match field - ie Grant Number appears in both tables & I've
created a relationship between them. This works great for the records
in Contacts that pertain only to one grant. My question is - how do I
relate several grants with one contact, so that this button in the
Grant table, in any of several records, takes me to its one contact?

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

You have to identify the contacts with a unique serial number and make a
number field for this number in both tables. Now you jump from contacts
to grants with the same contact number.

--
http://clk.ch

On Apr 24, 4:25 pm, roadwor... (AT) gmail (DOT) com wrote:
Instead of having a Grant ID in the Contacts table, have a Contacts ID
in the Grant table. Then relate on that field.

G