Modify_inc
Registered User.
- Local time
- Today, 03:47
- Joined
- Mar 25, 2013
- Messages
- 20
Hello all!
I'm trying to create a simple database to keep up with my few clients I provide service for. I'm trying to figure out the best way to relate my three tables I created: tblClients, tblDevices and tblJobs.
The way I see it is, Clients own Devices that require Jobs to service them, so at first I thought the tblClient would relate to tblDevices, and then tblDevices could relate to the tblJobs. But then I realized, not every client needs a job done on a device. Sometimes a client just needs consultation or other service that does not involve a device. What is a fairly simple way to resolve this as I'm still learning Access? Should I just add a non-device field entry to tblDevices or could I resolve this by using a Left Join type or any other ideas?
I'm trying to create a simple database to keep up with my few clients I provide service for. I'm trying to figure out the best way to relate my three tables I created: tblClients, tblDevices and tblJobs.
The way I see it is, Clients own Devices that require Jobs to service them, so at first I thought the tblClient would relate to tblDevices, and then tblDevices could relate to the tblJobs. But then I realized, not every client needs a job done on a device. Sometimes a client just needs consultation or other service that does not involve a device. What is a fairly simple way to resolve this as I'm still learning Access? Should I just add a non-device field entry to tblDevices or could I resolve this by using a Left Join type or any other ideas?