a question about Equipment Repair Database

[Nokia N93]

hello
am new in ACCESS and i really need you help , i have some questions about it , i don't know if this is allowed or not
I attached the db and my questions are :
1- in the order form i want when choosing the machine name, i want the machine code to be filled automatically in the field
2- i want the forms to be related to each other
meaning when i enter in the order form, when i click open maintenance form button, i want the machine name, code, and failure date to be fetched from the previous form
3- i want the same to the repair form
4- i also may ask if you can help me in arranging the forms
first the employee report the problem about the machine
then the manger assigns the problem to the specified engineer
then the engineer solve it specifying the spare parts and the quantity

and if there is something wrong in the tables

im sorry to write all these but i hope you can help Me
Many thanx in advance

[pkstormy]

Regarding...

1. You might want to look at the DLookup command or create a combobox which populates another field with the 2nd column of the combobox value selected.

2. You need to look at your table relationships first. Your current relational schematic doesn't really support relating forms/records in any real way.

3. Again - get the table relationships setup first.

4. This is more of a design issue specific to how you (and the users) want to set it up. You may want to look at some examples by others on different techniques (in the code repository or apps examples on this site). It's difficult for me to tell you how you should set up which form to drive which other form or how you should arrange your forms. There are many different ways. I suggest a 'Main Menu' type of form that opens first with buttons to open whatever form. Setting it up as if you were the user and what would be easiest for you to do what the app needs to do. This is something you should be working with the users of your application on.