I need your help with a database. Im working with Access 2000.
Ive created 4 tables and 2 forms. I have a couple of problems and a few things i want to add which i hope someone can help me with.
I have a Order form which a user inputs Order information.
My first Problem is that I have a cmd button that opens the "materials" form I used the wizard so it would open the linked record, however it did not open the form at all. So i created another cmd button without the linked field option just so that it would open the form.
My second problem is when i open the Materials form, i want the OrderID that is the foreign key to auto populate the related txtbox. how would i accomplish this?
The last thing is, I want to open the materials form and everytime i add some materials to the order i want it to appear in the bottom of the screen in some kind of list. is this possible to do?
I hope somone can take a look at this for me, i have attached the file.