By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

spare item management

P: 1
SUPPOSE THAT WE WANT TO PURCHASE A ITEM,(SPARE) ,THEN WE SHOULD FULLFILL ALL CRITRIEA
OF THAT ITEM,
FOR EXAMPLE,


ITEM DESCRIPTION (FOR THAT WE HAV 30 FIELDS)

UMC NO-(UNIQUE MACHINE CODE) TYPE- AN (ALPHA NUMERIC)
AREA-AN
**SUB AREA-AN
EQUIPMENT.
item description-an
item location- an
part/specification- an
make- an
storage location- main -AN
sub -AN

UNIT COST- CURRENCY
**COMPONENT TYPE
CRITICAL/GENERAL/CONSUMABLE-AN
MIN STOCK-N (NUMBER)

PLANT- 019/073/OTHER

PREREQUISTIC NO- N
RESERVATION NO- N
PO- N
PARTY-AN
DELINERY DATE- DATE/TIME
STATUS-AN
REMARKS- TEXT
INVENTRY- AN
INVENTRY DATE-DATE/TIME
MAX STOCK- N
PRESENT STOCK- N
USE LOCATION-AN (MEMO)

** COMPONENT TYPE


PROXIMITY
LIMIT SWITCH
MPCB
SENSOR
SPECIAL H/W(HARDWARE)

DC MOTOR
AC MOTOR
CONTACTOR
RELAY
CABLE
FUSE
THYRISTOR
ELECTRONICS EQUIPMENT
PB/IL/SS/ILPB
TIMER
HOOTER
TOOLS
AVIATION LAMP
ELECTRONOCS CARD



**SUB AREA
CASTER COM
CASTER#1
CASTER #2
CASTER#3
CASTER AUX
SCARFING
TRANSFER TROLLY
CTRT
SYMS
AUXILIARIES
NEW RCPH
OLD RCPH



AFTER THAT WE HAV CREAT FORMS

1). MASTER DATA FORM - IN WHICH ALL INFORMATION ABOUT THE ITEM WILL PRESENT.AND ALSO SUB FIELDS ARE BE PRESENT.THAT MEANS ALL THE 30 DESCRIPTION OF THE ITEM.

2). ORDER DATA FORM - IN WHICH ALL INFORMATION ABOUT ORDER WILL BE PRESENT THAT IS...........
PRE. REQUISTIC NO
RESERVATION NO
PO
DO
PARTY
DELIVERED
RECIVED
STATUS



3). INVENTRY FORM:-
INVENTRY NO-N
INVENTRY DATE- DATE/TIME
MAX STOCK -N
PRESENT STOCK-N
USE LOCATION-AN
USE NO'S -N
USE DATE -DATE/TIME
ORDER QUANTITY --NO'S




GENERATING QUERIES

EXAMPLE SEEN ON THE SENDED DATA BASE

THESE ARE:-
STATUS QUERY
LESS THAN MIN STOCK
GREATER THAN MAX STOCK
MATERIAL PURCHASE HISTORY
MATERIAL USE HISORY MATERIAL INVENTORY HISTORY MATERIAL ACTUAL VS INVENTORY MISMATCH






tell me how can i make adatabase in ACCESS using this fields, nd how can these are properly related to other relations
Jul 16 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
We can't do the work for you but we can help you to do it yourself. Have a look at this tutorial and I'll try to answer any questions if you have them.

Database Normalizations and Table Structures
Jul 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.