I�m making an application for our tool/plant hire company. I�m moving from, what I now think was probably my lash-up in A4, to hopefully something good in A5.
We have clients; who are either firms, or private people, or something in-between, or sometimes thieves! The private people rent for themselves, so no problem. The firms have authorised people; drivers/supervisors/etc, who they authorize to sign rental contracts.
So we have the situation sometimes where one firm has several staff, but also some of those people work for more than one firm, or work for themselves on weekends, etc.
So a many to many set, sometimes both ways?
So I�m thinking the best way to sort it out is:-
A set:-
3 tables:- personlist, firmlist, linklist.
personlist:- info of person, i.d. personal details etc.
firmlist:- info of firm, address, tax no, tel/fax, vehicles, etc
linklist:- a two field table linking persons to firms in both directions as required.
In the case of a private person, his firm details would be his own address, etc.
Then, I can make tables giving info of firms with all their staff; and a different table giving info of all the firms that any one person works for. Those are the tables I need to search on when a client wants to rent a machine.
I would appreciate advice, is this a practical way to deal with our situation, or any other suggestions?
Brian
We have clients; who are either firms, or private people, or something in-between, or sometimes thieves! The private people rent for themselves, so no problem. The firms have authorised people; drivers/supervisors/etc, who they authorize to sign rental contracts.
So we have the situation sometimes where one firm has several staff, but also some of those people work for more than one firm, or work for themselves on weekends, etc.
So a many to many set, sometimes both ways?
So I�m thinking the best way to sort it out is:-
A set:-
3 tables:- personlist, firmlist, linklist.
personlist:- info of person, i.d. personal details etc.
firmlist:- info of firm, address, tax no, tel/fax, vehicles, etc
linklist:- a two field table linking persons to firms in both directions as required.
In the case of a private person, his firm details would be his own address, etc.
Then, I can make tables giving info of firms with all their staff; and a different table giving info of all the firms that any one person works for. Those are the tables I need to search on when a client wants to rent a machine.
I would appreciate advice, is this a practical way to deal with our situation, or any other suggestions?
Brian
Comment