G
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é.
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é.