Design for lot control

[reisenhardt]

I am new to Access and I am trying (unsuccessfully so far) to design a
database for our wafer lots. I have entered all of the information into a
spreadsheet in both Record and Field format. I have tried using the Data
Wizard but am unable to get what I need in terms of Primary Key. The assigned
lot number is assigned externally. Each lot has up to 24 different wafers.
Each of those wafers has different bits of information associated with it (J-
ID, J-Thk, J-TTV, T-ID, WSY).

I could struggle along in spreadsheet format, but would like to make it
easier for the Production crew to enter the data about the wafers into each
lot's record.

Everytime I have tried to pull the table into Access in the Record format
(non-normalized), I cannot make sub-tables with more than 15 entries (limited
in the Wizard). I thought this might be the best way to do this since the Lot
to J-ID is a 1 to Many relationship (J-ID to all others is Many to Many, up
to 24).

When I try to pull the table into Access in the Field format (normalized), it
does not allow NULL values for my Primary Key Field (Lot Number).

Any thoughts and / or suggestions would be most appreciated.

Thanks,
reisenhardt

 

[Guest]

Seems like you need to tables at least - Lot and wafer.
LOT ---
LotID - autonumber - primary key
LotCode - text
LotDate - DateTime
etc.

Wafer ---
WaferID - autonumber - primary key
LotID - onumber - integer - foreign key (associated with Lot table)
WaferType - text
Pass - Yes/No
etc.

 

[reisenhardt]

Thank you for the feedback. Once you got me started thinking along this line,
I decided to repeat the lot number for each wafer in each lot and allow the
Primary Key to be autonumber, then Import the data into Access. I then pulled
LotNumber into it's own table (as lookup) in the Wizard. This seems to work.
I need to think about this more so that I can come up with a form that's easy
for Production to dump the data into.

Thanks again,
reisenhardt

Seems like you need to tables at least - Lot and wafer.
LOT ---
LotID - autonumber - primary key
LotCode - text
LotDate - DateTime
etc.

Wafer ---
WaferID - autonumber - primary key
LotID - onumber - integer - foreign key (associated with Lot table)
WaferType - text
Pass - Yes/No
etc.

I am new to Access and I am trying (unsuccessfully so far) to design a
database for our wafer lots. I have entered all of the information into a

[quoted text clipped - 21 lines]

Thanks,
reisenhardt

 

[Guest]

You need form and subform -- Lot and Wafer.
--
KARL DEWEY
Build a little - Test a little

Thank you for the feedback. Once you got me started thinking along this line,
I decided to repeat the lot number for each wafer in each lot and allow the
Primary Key to be autonumber, then Import the data into Access. I then pulled
LotNumber into it's own table (as lookup) in the Wizard. This seems to work.
I need to think about this more so that I can come up with a form that's easy
for Production to dump the data into.

Thanks again,
reisenhardt

Seems like you need to tables at least - Lot and wafer.
LOT ---
LotID - autonumber - primary key
LotCode - text
LotDate - DateTime
etc.

Wafer ---
WaferID - autonumber - primary key
LotID - onumber - integer - foreign key (associated with Lot table)
WaferType - text
Pass - Yes/No
etc.

I am new to Access and I am trying (unsuccessfully so far) to design a
database for our wafer lots. I have entered all of the information into a

[quoted text clipped - 21 lines]

Thanks,
reisenhardt

 

[reisenhardt]

Karl
Thank you! I got Access Wizard to let me create the Form/Subform, everything
is now working - way cool. Only problem is that I cannot directly cut and
paste from Excel into the form; I guess I'll have to work on that (the
incoming data is in column form).

Thanks,
reisenhardt

You need form and subform -- Lot and Wafer.

Thank you for the feedback. Once you got me started thinking along this line,
I decided to repeat the lot number for each wafer in each lot and allow the

[quoted text clipped - 25 lines]