Can I run this past, anyone, with the knowledge? I am still trying to figure this out as IT has said NAY to a database as new CRM is coming soon (18months is soon apparently!!).
1 client can have many different pieces of Equipment.
1 category can have many brands
1 brand can have many types
1 equipment can have 1 ID (Asset number and Ident)
1 client would have 1 install date per piece of equipment at a time - but it could be removed and installed again at a later date.
1 client would have 1 removal date per piece of equipment at a time - but it could be installed again later.
1 Equipment will have many install dates with Many clients
1 Equipment will have many install Removal dates with Many clients.
1 Equipment will have many service dates - these do not depend on clients. Equipment is serviced whether on location or store.
When looking up a piece of equipment it will show all its info - where it is (client) and when it was serviced, last service Date, the cost, and if it has an agreement.
I would be pulling data from it for another company - showing the client and equipment info together on one table (that would be a query yes?)
Am I on the right track?
1 client can have many different pieces of Equipment.
1 category can have many brands
1 brand can have many types
1 equipment can have 1 ID (Asset number and Ident)
1 client would have 1 install date per piece of equipment at a time - but it could be removed and installed again at a later date.
1 client would have 1 removal date per piece of equipment at a time - but it could be installed again later.
1 Equipment will have many install dates with Many clients
1 Equipment will have many install Removal dates with Many clients.
1 Equipment will have many service dates - these do not depend on clients. Equipment is serviced whether on location or store.
When looking up a piece of equipment it will show all its info - where it is (client) and when it was serviced, last service Date, the cost, and if it has an agreement.
I would be pulling data from it for another company - showing the client and equipment info together on one table (that would be a query yes?)
Am I on the right track?