Building Form

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

 

[Dennis]

I hate to say this, but I have NO IDEA what he asked.

 

[John W. Vinson]

I hate to say this, but I have NO IDEA what he asked.

I have read it three times and I have no idea either.

John W. Vinson [MVP]

 

[gatarossi]

Dear all,

Let´s think in a form like a pivot table (but not exactly a pivot
table, because I have a problem: I will use this form to include to
alter or to exclude values - not for consults) :

In the page (form) we have the filters: profit_center and date*
In the column (subform) we have the dates that I selected in the
filter-field date
In the lines (subform) we have the expense_code, expense_description
and values

* date: it will be a multiselect listbox or combobox that consist in:
when we select the date, the date will appear in the column's position
in my form

Then what the user will do (for example):

I would like to include values in 01/02/07 and to alter values in
01/01/07 in the industrial profit_center:

Then in the combobox/listbox profit_center in my form I will select
the industrial profit_center.

After I will go to my second filter in my form: the dates. Then I will
select the months 01/01/07 and 01/02/07 (when I select this two months
it will appear in my subform two columns referring these months) yes -
it´s like a excel sheet or a pivot table!

Then I go to my subform (it's like that):

expense_code expense_description 01/01/07 01/02/07
10 salary
10* 11*

* these are the values that I need to include, to exclude and to
alter!

It's clear now?

Thanks a lot!

André.