Creating a database design

[thanosgr]

Hi
in my office we do a lot of paper work and its time to do it in access and then do some reports.
What we have
is
A request form, Colleagues are submiting to me a request form what supplies they want.

Eg RequestFormid, requestformdate, and requestproducts, Items,Potential Cost, Branch Area.

Also we

To mention the requestproducts, there are non exists in our warehouse.

After gets a preaprove in our account department

Comes the suppliers. They bid the specific requestformid, The chepest gets the offer

At the end of the month i have to collect all the offers and the bids, with the product in a word sheet, group by department..

For example

Month February 2012, All the requestforms with the suppliers(and all the details) from the department A
Month February 2012, for the department B, and so on..

Any idea how to create the Form, so i can choose each time for which department i have to add all those detaisl, plus the month, year.

Thanks



Thanks

[June7]

Have you even designed the database structure yet? Figured out data entities and relationships and built tables? Refer to this:
http://forums.aspfree.com/microsoft-...es-208217.html

Check out tutorials at http://datapigtechnologies.com/AccessMain.htm especially the ones on comboboxes in Access Forms: Control Basics section and Building a Custom Filter in Your Form in Access Forms: Tips & Techniques section

[thanosgr]

Thanks for the info