Johnsonsimon
Registered User.
- Local time
- Today, 03:59
- Joined
- May 5, 2012
- Messages
- 45
Hello all,
This is my first post here so please be gentle, although been browsing for a while I apologise for jumping in at the deep end, but I have been googling and searching around everywhere and can't find anything. It could be that I am searching for the wrong thing or asking in the wrong way but I really can't find anything.
The DB I am building is for my father's currently small chauffeur company in order for them to input the details of the jobs to have a record of future, and completed jobs and also to produce printed and PDF job sheets for each job.
This is how I currently have the DB setup;
Tables:
Client
Driver
Vehicle
Jobs
Each of these tables has its own form setup and all works great.
My issue is with a feature request that my dad's business partner has put forward.
The client table has fields; CLIENT ID, CLIENT NAME, CLIENT CONTACT NAME, CLIENT CONTACT NUMBER, ADDRESS (lines 1-3), POSTAL CODE.
What he has requested is to be able to enter more than one CLIENT CONTACT NAME & CLIENT CONTACT NUMBER for each client, as often with big companies there is more than one person who books jobs. They do not wish to simply have a seperately client for each client contact. Is this possible. Would it require a separate table or can it be done directly in the client table.
When booking a job they go to the job booking form which allows them to choose the client from a combo box, with the above issue fixed they would wish to choose the client from a combo box still and then choose the contact person for this client from another combo box which would then also show this persons contact number.
The second question is of a similar vain to the first, also in the jobs booking form there are text boxes LEAD PASSENGER NAME & LEAD PASSENGER CONTACT NUMBER, which are currently linked to txt fields in the jobs table. What they wish to be able to do is be able to choose the leade passenger from a combo box, but it needs to be client specific (filtered?), based on the client chosen from the CLIENT combo box. When they choose the lead passenger it should also display their contact telephone number.
E.g. They choose 'Company X' from a combo box, and then the Lead passenger combo box is populated with passenger names for that particular client.
I hope that makes some sort of sense. I can post a link to the DB if it would help at all.
Or I can answer any questions to try to help anyone understand my request more clearly.
I really appreciate the help in advance.
Simon
This is my first post here so please be gentle, although been browsing for a while I apologise for jumping in at the deep end, but I have been googling and searching around everywhere and can't find anything. It could be that I am searching for the wrong thing or asking in the wrong way but I really can't find anything.
The DB I am building is for my father's currently small chauffeur company in order for them to input the details of the jobs to have a record of future, and completed jobs and also to produce printed and PDF job sheets for each job.
This is how I currently have the DB setup;
Tables:
Client
Driver
Vehicle
Jobs
Each of these tables has its own form setup and all works great.
My issue is with a feature request that my dad's business partner has put forward.
The client table has fields; CLIENT ID, CLIENT NAME, CLIENT CONTACT NAME, CLIENT CONTACT NUMBER, ADDRESS (lines 1-3), POSTAL CODE.
What he has requested is to be able to enter more than one CLIENT CONTACT NAME & CLIENT CONTACT NUMBER for each client, as often with big companies there is more than one person who books jobs. They do not wish to simply have a seperately client for each client contact. Is this possible. Would it require a separate table or can it be done directly in the client table.
When booking a job they go to the job booking form which allows them to choose the client from a combo box, with the above issue fixed they would wish to choose the client from a combo box still and then choose the contact person for this client from another combo box which would then also show this persons contact number.
The second question is of a similar vain to the first, also in the jobs booking form there are text boxes LEAD PASSENGER NAME & LEAD PASSENGER CONTACT NUMBER, which are currently linked to txt fields in the jobs table. What they wish to be able to do is be able to choose the leade passenger from a combo box, but it needs to be client specific (filtered?), based on the client chosen from the CLIENT combo box. When they choose the lead passenger it should also display their contact telephone number.
E.g. They choose 'Company X' from a combo box, and then the Lead passenger combo box is populated with passenger names for that particular client.
I hope that makes some sort of sense. I can post a link to the DB if it would help at all.
Or I can answer any questions to try to help anyone understand my request more clearly.
I really appreciate the help in advance.
Simon