PC Review

Thread Tools Rate Thread

Maintenance Log

Posts: n/a
      13th Sep 2005

I want to create a table which has 4 columns.

ID (Primary Key) Machine Name Machine subsection Room
1 MPP1 St12 - PnP
2 MPP1 St22 - Reject
station XP03
3 MPP2 St03 - Vision
system XP16
4 MPP2 St07 - Splice
detect XP16
5 Converter System die station
6 Converter Lane Die station
7 Casting Line Anvil Die

I want to be able to have another table which will be populated using a form
which will allow the user to select the machine name in one field on the
form and depending on the selection it will change a list available in
another field which will allow the user to enter a machine subsection. I
want the second field to be limited to the options associated with that
machine. There is approx 30 machines and each might have up to 20 sub parts
which the user will be able to select as they wish.

They will also be typing in to other fields which will have problems and
work carried out on that machine. This will be used as a handove database
from shift to shift and also for management to query as they wish.

Any ideas or help or examples.



Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintenance/activity log duplicate date total last max unique dist =?Utf-8?B?VGltIENhc3NhZHkgSnIu?= Microsoft Access Queries 1 22nd Jul 2005 07:46 PM
Need help with a log off/log on problem...can log off then log on dif. user and system will be slow loading user settings, then play start up music, then show wallpaper, then freeze. Ralph Malph Windows XP General 2 9th Feb 2005 07:05 AM
Maintenance log sheet for a brush chipper. =?Utf-8?B?Y29vbGRvZw==?= Microsoft Excel Misc 1 29th Jan 2005 01:43 AM
Maintenance log Dennis Allen Microsoft Excel Programming 1 7th Sep 2004 08:42 PM
Maintenance log book Peter Chapman Microsoft Outlook Discussion 3 8th Jun 2004 09:39 AM




All times are GMT +1. The time now is 03:46 PM.