Trying to figure out how to setup access tables as a setup checklist for devices.
Posted on 2012-09-10
For the life of me I can't seem to figure out how to set up these tables. Basically I have 3 tables.
1) tblDevice: DeviceID(primary key), DeviceName
2) tblChecklist: SeqNum(Primary key), Task
3) tbldeviceChecklists: DeviceID, SeqNum
I want to be able to pull up a list of all my devices and have it tell me which tasks have been completed and which still need to be done. The main problem I'm having is that if I want to add or remove tasks i don't know how to push that to the tblChecklist so that those tasks show up on all the devices.
Any ideas or anyone know of a template hanging around somewhere?
Thanks for any advice and help on this one!