asked on

Trying to figure out how to setup access tables as a setup checklist for devices.

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!

Rey Obrero (Capricorn1)

check this demo

http://office.microsoft.com/en-us/access-help/demo-set-the-relationship-between-two-tables-HA010254901.aspx?pid=CH100739911033

Jeremy Campbell

ASKER

I'll get into that this morning and get back to ya!

Thanks!

Oliver Wastell

Will all the tasks in tblChecklist always apply to all devices? If this is the case then the solution would involve listing all tasks in tblChecklist for any selected device. When a task is completed for the selected device, a checkbox for the task is ticked which then creates a link record in tblDeviceChecklists (a rename might be appropriate to tblDeviceTaskComplete).

The tricky bit is getting the checkbox to appear against the list of tasks, and to have these checkboxes checked if there is a link record in tblDeviceChecklists (or the renamed version). I'm happy to help with the VB code if I have interpretted your requirement correctly.

Oliver

Jeremy Campbell

ASKER

Oliver, you nailed it.. That's exactly what I'm trying to do.. Just couldn't get the queries setup to handle it and get it working.. I'm extremely sorry for just getting back to this question. I don't normally get pulled away for that period of time but another hot project came up that needed to be tended to 100%.. In any case If you could help me through this a bit that would be greatly appreciated!

Oliver Wastell

Hi Seyer, no problem. I'll happily help you with it. I'm taking a look now.

ASKER CERTIFIED SOLUTION

Oliver Wastell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeremy Campbell

ASKER

Sorry I'm really being bad about this question.. Looking at this right now and I'll get back within the hour! Thanks for your patience!

Jeremy Campbell

ASKER

This will get the job done! Thanks a bunch!

Oliver Wastell

Pleasure ;-)