Hello again all,
I have not had any internet access for quite some time now, so this project has been put on the back burner, but now I am getting "pressure" from the powers that be to get it completed.
I really appreciate all the input from both Guus and cplmckenzie, but I am yet again completely stuck.
I have looked at the alterations again, after these few weeks away, that cpl made and I am at a complete loss as to where I am up to. I feel really bad for keep coming back with question after question.
If cpl or anyone can get the databse into a useable state, I can try to get back on board with the rest of the 'development'.
As discussed earlier in the thread I just need to be able to do the following;
Jobs & Booking Form
When the CLIENT is selected from a combobox (drop down box), a further drop down box is populated with the CONTACTs for that client. When selected this info needs to be saved/stored in one of the tables, I presume the Job Table would suffice.
Also on this form on the JOB DETAILS tab, I need to almost repeat the above but for LEAD PASSENGER.
These need to be editable in some way, by opening another form to be able to add CONTACTS and/or LEAD PASSENGERS for the currently selected client. It would also be handy if it was possible to just overtype what is in these boxes should an adhoc (non-regular customer, contact or lead passenger) need to be entered.
CLIENT FORM
Need some sort of subform that displays ONLY the CONTACTS for the currently selected CLIENT, this subform should also allow the editing or addition of new CONTACTS for the currently selected CLIENT.
I would also need the same functionality for LEAD PASSENGERs. Whether this is to be done with another table for passenger details or via some form of query or filter.
As per previous recommendations I plan to delete the COMPLETED and CANCELLED jobs tables and incorporate a field(s) in the Jobs table to take care of this function, and base a query on both of these that will populate the COMPLETED and CANCELLED jobs forms.
I really hope someone can help with this as my head is completely pecked.
I feel totally guilty for asking others to do some or even any of the work, if anyone can give me detailed directions on how to proceed I will undertake the work myself.
Thank you all so much again.
Si