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?

Thanks
Matthew

"Buckbuck" <buck.matthew74 (AT) yahoo (DOT) com> wrote

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 )