building form/subform

G

gatarossi

Dear all,

I'm having problem with building a form:

In my database I have these tables:

1) expense_code - fields: expense_code, expense_description
2) profit_center - fields: profit_center_code,
profit_center_description
3) period - fields: period
4) expenses_control: - fields: expense_code, profit_center, period,
values_USD

I made a relationship between the fields in the three first tables
with the last table, the name of the fields are the same.

Then I have tried everything to do a form/subform to update/include/
exclude values in my table expenses_control (since Mai/07!). My
problem is that I need that the form/subform has this layout (more or
less an Excel´s sheet):

Form:
profit_center (combobox): the user will select the profit center
period (multiselect listbox): the user will select as many dates as he
wish, and for each date selected will appear one column in the subform

Subform:
expense_code first date selected second date selected third
date selected ...
salary 100
110 120
taxes 50
60 70
..
..
..

Is it possible?

Thank you.

André.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining Form with Subform 2
Building Form 4
Building Form 3
Building Form's Filter 0
Update Values in Unbound Fields 0
Second "Filter" in Forms 0
Dynamic Forms 2
Umbound Fields 0

Top