Hide records in Value Lists?

[SirKaKo]

Hi !

Let me start by saying I'm totally new to FM and have only "watched" a couple of tutorials. I have no experience in db of any sort. Anything to get started, right? I have now made my first database and have gone to an extent where I have many tables with many fields and many, many inconsistencies...

How would I make a value list display only certain records from a table. I mean, i.e. I have a table named AGENDA, where I stored CUSTOMERS, SUPPLIERS and EMPLOYEES, then I have the field EMPLOYEES in the table INVOICES where I would like to show only the employees and not the customers and suppliers, so I created a Value List from the field AGENDA ID so a pop-up menu would input the values, but the pop-up menu shows all the records from the AGENDA (which are coded differently: AGENDA ID is "E-001" for employees, "S-002" for suppliers and "C-008" for customers, serialized).

So I want the Value List to show only the values from a field from certain records so I can choose which employee made an invoice without seeing all my agenda as an option.

Am I making any sense?

Thanks in advance!

Rick.

[QuinTech]

Hi, Rick, and welcome to FM Forums!

Check out this link and this link to get you on the right path.

HTH,

Jerry