here's a screenshot of step 4.
Is your layout based on PayRoll or Invoices?
Why is there an inequality operator (<) specified instead of the default (=)?
How exactly did you define the company value list for the drop down?
Is this a use values from a field value list?
What options did you select on the dialog that appears when you select this option for your value list? (a screen shot may reveal why this isn't working).
Are any of these steps redundant?
Probably not, but you have not described what you want to do once you have this value list working so that you can select a company from this drop down list. You may find this thread to be of interest: Auto Fill
My layout is based on payroll.
Have made the operator =, that was my misunderstanding.
I defined the company value list via File > Manage > Value List... > New > Use value List from another file > then select the company value list from the invoice 2 file.
This is what I want - Create a payroll database where I can select particular invoice fields from my Invoice database. The payroll database also has custom number & calculation fields that I've created.
Have I answered your questions correctly?
Auto-fill is where I am heading, I want to auto fill certain fields based on which invoice I have selected.
I am going through that other thread now
And how is that value list defined in the other file? What options did you specify in Manage | Value Lists in the other file?
Since you have a table occurrence to Invoices in your current file, you can simplify things by setting up the use values from a field option to list values from the Company table without having to refer to a value list in the company file--though that should work for you if it is correctly set up. Either way, that screen shot that I requested of the relevant dialog may clarify why you aren't seeing a value list in the field.
That value list is from the Invoice starter solution, from Layout : Customers : Company.
here's the screen grab, that the one?
this might be what you're asking for sorry
Phil, I'm good have fixed it
many thanks for your help in doing so