N
nirenjoshi
I am new to MS Access and need urgent help to develop an application.
Here's what I want -
I have a query ( which gets records from SQL server database tables)
which has columns named LotID and WaferID. Multiple WaferIDs have the
same LotID. So, for example, Wafers AU1234-05 and JS1234-09, both have
the same LotID A1234. Now I want to create a table named WaferInfo,
which will have WaferID as one of the columns (same waferIDs which
appear in that query I mention above). In addition, there will be other
columns pertaining to properties of wafers (like thickness, density,
size, etc).
I want a form wherein I enter a LotID and all the Wafers showup and
then I can enter the properties on the form for each individual wafer.
All that info should go into that second table named WaferInfo.
SO, here are my problems -
1. How do I get the Wafers for a given LotID (from the query), when I
enter a LotID in a Textbox?
2. Lets say I got the Wafers for a given LotID, how do I get this info
into the WaferInfo table? I need to take into account the fact that
some wafers might have already been entered in the table along with
their properties, while other wafers' properties need yet to be entered
via the form.
Any help/advice/suggestions are most welcome.
Thanks!
Here's what I want -
I have a query ( which gets records from SQL server database tables)
which has columns named LotID and WaferID. Multiple WaferIDs have the
same LotID. So, for example, Wafers AU1234-05 and JS1234-09, both have
the same LotID A1234. Now I want to create a table named WaferInfo,
which will have WaferID as one of the columns (same waferIDs which
appear in that query I mention above). In addition, there will be other
columns pertaining to properties of wafers (like thickness, density,
size, etc).
I want a form wherein I enter a LotID and all the Wafers showup and
then I can enter the properties on the form for each individual wafer.
All that info should go into that second table named WaferInfo.
SO, here are my problems -
1. How do I get the Wafers for a given LotID (from the query), when I
enter a LotID in a Textbox?
2. Lets say I got the Wafers for a given LotID, how do I get this info
into the WaferInfo table? I need to take into account the fact that
some wafers might have already been entered in the table along with
their properties, while other wafers' properties need yet to be entered
via the form.
Any help/advice/suggestions are most welcome.
Thanks!