Building Form's Filter

[gatarossi]

Dear all,

I have tables with this fields:


expenses_control: expenses_code, profit_center, date, value.
date: date
profit_center: profit_center_code, profit_center_description
expenses: expenses_code, expenses_description


The relationship between the tables are:


expenses_control.expense_code = expenses.expense_code
expenses_control.profit_center = profit_center.profit_center_code
expenses_control.date = date.date


Now I'm trying to do a form to imput, to include and to exclude data/
values (not for consults!), like that:


---------------------------------------------------------------------------­---------------------
EXPENSES CONTROL
Form:
profit_center:__A______________(it's a combobox where the user will
select the profit center).


profit_center_description:_industrial_(it will change according to
profit_center combobox).


date:____________(it's a multiselect combobox where the user will
select the dates - below I will explain better how it must work!!!)


Subform:


expense expense_description 01/01/07 01/02/07 01/03/07
10 salary 10
10,5 11
20 other expenses 2
1,5 3


---------------------------------------------------------------------------­----------------------
Now it's my problem: We can see in the column of the subform whith
the
dates, before I describe my problem, the information in the table is
like that:


expenses profit_center date value
10 A 01/01/07 10
10 A 01/02/07 10,5
10 A 01/03/07 11
20 A 01/01/07 2
..
..
..


Can I choose dates in the multiselect combobox of my form and it's
appear in columns in my subform? (to include values, etc - not only
to
consult).


Thanks!!!


André.