IN CONTACTS table
I have a field that lists of contacts - (NameCompany).
Some NameCompany might be noted through a field drop down list as a
Customer.

On my Invoice Layout I want to create a Customer selection tool that
presents through a drop down Value Listl NameCompany that is Customers
only.

Presently my Customer selection tool is a NameCompany selection tool.
Invoice and Contacts are related through a LINES table. The
relationship between Contact and Invoice is manage accordingly:

INVOICE
kf_Contact_ID

LINES
kf_Contact_ID

CONTACTS
kp_Contact_ID

i imagine this is enough for you to understand my intention. How do I
handle this?

Thanks

On Jan 3, 11:24 pm, buck.matthe... (AT) yahoo (DOT) com wrote:
Let me see if I understand. You want a user to able to create a new
Invoice and select a Contact record to relate to it. The choice of
Contact should be limited to those Contacts labelled "Customers". Is
that correct?

If so, and you're using FM7+ (you don't say), you're looking for a
filtered value list. You want a list of values of NameCompany from
the Contacts table. So you need to make a new field in the Contacts
table that is a global calc with a text result = "Customer". Create a
self join (relate one Table Occurance of Contacts to another TO of
Contacts relating the ContactType field to the new global field. Then
create a value list that picks the key field from the new "child" (non-
global) TO starting from the parent/global TO. That will produce a
list of ids of the records marked "Customer".

Good luck.
G