Search the Community
Showing results for tags 'lookup table'.
I have a tabular report containing afield that has a lookup table associated with it (1 to many relationship). How do I do a search in the table for rows that have a value that is contained in a lookup table. E.g.I have lookup table of Department ID & Department name. In my tabular report of employees with Employee ID, Employee Name, Department ID (each employee belongs to a particular department) I want to search for Employees belonging to a department, using the department name rather than Department ID. And I want the search to be able to use "Contains" e.g. bring up all Employees w
I have a lookup table that lists several (around 20) items to check off in a to-do list where the table is named â€œtodoâ€ with fields setup as todo_Num (integer), todo_Item(integer) todo_Desc(text) and todo_Cat(text). I also have a â€œtodo_completeâ€ table with the fields of Comp_Num (integer), todo_num(integer), Fin(checkbox) and Explain(text). I have been able to setup a submission form with virtual1 field displaying the todo Descriptions in a dropdown with 2virt fields cascading the todo_Num and todo_Item, from todo_desc then linking to the todo_complete table. Unfortunately the dropdown