Hello.
I have a project, and it contains a Table called account and a field called staff_name.
I have a custom view that looks at a Table called job, and has two fileds which I am looking at, Job_Finished, Payment_Received.
It also loks at a Table called Labour that has a field called Shets_Returned.
I go to my visual editor and double click on the field of Staff_Name, select Lookup wizard, select lookup table, I select account on the Table list and select Link field and Display Field and select Staff_Name for the two selections.
I select Lookup wizard as edit box with AJAX popup, but when I run the program, It wont seem to work.
I know I have a staff name as PG in the database, but in the search box, I enter p and it just displays the box as red and does not suggest anything??
ANy ideas please?
Thanks
Paul.