Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1437

Re: Contacts within a Contact

Show all headers | View raw

"Buckbuck" <buck.matthew74@yahoo.com> wrote in message
news:88b1aca5-9b94-4fbd-98d4-bf59ff98ce35@z3g2000prz.googlegroups.com...
> FM 10
>
> I have CONTACT database that has potentially eight contacts -
> employees. I also have a related INVOICE database. Is there away to
> create an Invoice for a CONTACT and then be able to select a contact
> employee such that their email and contact number appears, through a
> lookup or otherwise?

It depends on how your database is set-up, but usually it would be something
along these lines.

You would need to have at least three tables:

     Invoices
     Contacts
     Employees

(The Invoices may or may not also need a sub-table for the line items.)

Each Contact table record would have a unique ContactID used to link it to
the related Employee table records.

In the Invoices table there would be a value list which retrieves it's
values from all the records in the Contacts table. Users can pick a Contact
from a pop-up field using this list and the data (perferably the unique
ContactID rather than the Name) can then be used as the link for a
relationship from the Invoices table to the Employees table to retrieve all
that Contacts' Employee Names for a second value list / pop-up field for the
user to choose from.

The data in this second pop-up field (again perferably a unique EmployeeID
rather than their name) can then be used in a relationship from the Invoices
table to the Employees table to retrieve the appropriate email address,
phone number, etc. details.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Contacts within a Contact Buckbuck <buck.matthew74@yahoo.com> - 2011-01-31 15:33 -0800
  Re: Contacts within a Contact "Your Name" <your.name@isp.com> - 2011-02-01 18:41 +1300

csiph-web