Joined: 10 Aug 2012
|Posted: Fri Aug 10, 2012 7:00 am Post subject: Idea in creating a form
I am new to this forum as well as using Open Office Org. I am using the latest version of OOo 3.4
I am facing an issue in writing data to the table from a form. I went through many posts in the forums but in vain. Finally I got tired and am writing this post. I would be very grateful if anyone can give me a solution for this issue.
The problem I am facing is:
I am trying a develop a database of rates of items of different projects which has the following tables - fields:
1) type of Project - Project Type
2) Projects List - Project ID, Project Name, Project Type
3) Category List - Category ID , Category Name
4) Items List - Item ID, Category ID, Item Name, Item Unit
5) Rates List - Project ID, Item ID, Rate per unit, comments
The rates are unique for each of the items under different projects.
There is a fixed list of types of projects. I created a form to add and modify projects under those projects. I created a form to add/modify categories and add/modify items.
Now I am trying to create a form to add/modify item rates. I want to select an category & item and Project type & project from the existing list and add a rate to that particular item under that project. And later also be able to modify rates by choosing an item & project. It is a many to one and one to many relation.
I could not find a way to create such a form. I am also fine with creating 2 forms and linking them both but I want to add a rate without the necessity of entering Project Id or Item ID.
I even tried using macros but I could get the required function.
Somebody please provide me a solution for this issue.
thank you in advance.