Bring data from a form to another form when an event is trigger

[cwwaicw311]

Hi,

I currently working on a simple Inventory Tracking System. I have 12 form to input and calculate balance for 12 different material. I have a form act as a main menu to go to this 12 form. The input from the form is store in 12 respective table . In each of the 12 form I have include a trigger whereby when the event of inventory reach it lowest balance/limit (i set it as 100) a message box would prompt out telling user to order more inventory.

My Supervisor wanted a new request is when the event happen (the msg box prompt out) in the meantime the item name, date and the balance to be send to the main menu form. So whenever user open main menu form they know which inventory in need of re-ordering. Could this be done...??

I have attach my database hoping someone can guide me to finish this request. I reli need help on solving this problem. Been stuck for a long time.Thank You.

[mshmyob]

Oh my..... I would suggest you read up on normalization.

cheers,

[cwwaicw311]

Erm... by normalization do u mean i should store my data into 1 table... If can i wish u could explain more to me about wat should i do to make database more efficient.... Thank...

[mshmyob]

No.

First write down what you want this database to do. Then each entity (subject - each set of related data) of your database needs a table with a primary key.

For instance not knowing exactly what your database is for or what you are trying to accomplish I can see you need a table for :

Operator
M/C
Shift
Component (I don't know what Capillary, Lead Frame, etc. is so I will just say they are components)

and more tables for to tracking inventory and the time etc.

But you need a good explanation of database before coming up with a final design.

You do not create a form for every component you have and hard code combo boxes to pick operators, M/C, etc.

Again read the article on normalization.

cheers,