Have you seen the ValueListItems ( ) function?
I have tried this for my database.... it doesn't work.
Have a table with Employee Information with fields:
Then I have a table Printer Selection:
Printers -> Calc field as: ValueListItems("Employee Information::printer1(paragraph symbol)Employee Information::printer2Employee Information::printer3(paragraph symbol)Employee Information::printer4(paragraph symbol)")
then I have a field in my main table as a popup menu with the value list pointing to my calc field.
shows "no values defined" What am I missing?
This doesnt make any sense. You should have a printers table. What is the objective here? Is is to assign a default printer to each employee?
forgive my wording.... I'm fairly new at this, and this is my first "major" project.
each employee can have up to 4 printers assigned to them. What I'm trying to do is based on what they have assigned in the employee information table, I want that data to reflect on the inventory signout layout when they get supplies for their printer.
so I want printer1, printer2, printer3, printer4 to beconverted into a value list for each employee based on what the field values are for each.
then on the signout layout, when I seelct the employee, there can be either a drop-down, pop-up, or even a checkbox set, of those printers for the selected employee. so that I can signout supplies for the selected printers for them.