Creating a value list of suppliers

[RichardBurrow]

Hi folks,

I am hoping this should be relatively straightforward to sort out but its got me a bit stumped.

I am building a print management workflow solution. I have a table called Contacts where

customer data, general contact data and supplier data is stored. Each record is either tagged

as being "Customer", "Contact", or "Supplier".

I have built another table called Purchases where we can raise purchase invoices and relate

them to suppliers.

What I would like to achieve is a drop-down value list on the Purchases layout which only shows

records from the Contacts table that are tagged as "Supplier".

I am not quite sure how do get this to work... could this be achieved using a self join relationship

with the Contacts table?

[bcooney]

Another post that suggests Graham. See this thread: Link. Long-term, this may be your best approach. Especially if a Contact can be a customer and a supplier.

Or, take apart this demo.

CertainContactsVL.fp7.zip

[comment]

I'd prefer to do it this way.

CertainContactsVL.fp7.zip

[bcooney]

Actually, although we showed him how to create the value list, a popup of suppliers will probably grow to be too long. I'd use a Select button with a popup list...and it would be showing a list from a TO of the Supplier subtype of Contacts.

PopupSelectDemo.fp7.zip