Search results

I know what you mean, I have started to create the forms please see attached however my next form tbl job details i am having trouble with, when you select who the engineer to assign it to it does not auto display branch how can i do this. or the engineers telephone number also when i...

Thanks for that been away for the weekend so not had chance to look at it, so with this layout I would be able to create one data entry form as such i just trued creating one for customer name and address details by address and it said data not in record set. by using form wizard

sorry ignore last message noticed that customer table is only linked to names would it not be linked to jobs as well as one customer can have many jobs/cases will this now allow me to do the form desighn i am after, also hpw do i do them selection optopn and lnk them to job type,

so what or where would junction table go and where would the forigen keys go.

Thanks i dont know as it is where i thought is should be my thinking was this one customer can have many contacts yes there would be more employees at any given branch but for assigning calls to engineers it would only be the engineers who do jobs so it would be one branch can have many...

Hi Can anyone look at my table structure to see if it works not sure about relationships though, as im trying to create one form with multiple subforms on it Thanks

hello gina r u there

Hi I have re-done the table again lol calldetails would be like your acivity table etc. hope that helps, easier to use my tablenames as i know then what each table is for, i have tried to put descriptions in as well. the only think i cant figure out is the sub forms the relationships and how...

Hi. I attached the template to show you the main call details form in order to show you what I was tryint to create myself not that i want the template altering. lol so please feel free to start from scratch on how you would do it.

cals would always come from the customer dispatch to engineer would like it to be a command button that opens up dispatch form to select who dispatched it time and date and to which engineer. then it reopens the same form with the dispatch information displayed after you have filled it in...

Ok Tables are done see attached. Just bit unfamilar with some of the table name you have used so i will describe the process for you encase you need to modify table design. customer calls in and they do not have a contract so we take there name address details etc Date and time of call is...

The only one bit I do not get cCase il do the tables and then post them back here to see if they are write., some of them may change names but thank you.

Can you advise as to what is wrong with the tables as i have been working on this for over a week lol and what I need to add/delete. I am all up for learning but I learn better through doing/following instructions.

Sorry Gina The calls table should be call type. So basicaly at the moment looking to enter 1 call per customer but sometime that customer may require a return visit so one customer can have many call or one call. I am a little new to Database and relational Show how would it be best to...

basicaly the form i have created is based onn one form and various table no sub forms, the greyed out boxes when you click dispatch you fill in the dispatch form details and it autmaticaly shows them on the main form but are greyed out to stop you from altering them. Anyhow i keep getting told...

Im trying to design a database and think subforms make a form look untidy, so do you need to have subforms or if i was to use web database instead would subforms go out the window here what i have so far all on one form but the gryed out boxes do not auto populate.

The call tracker that i have tried to ammend for my own purposes is to log non contracted call outs, where by we log the call and then verbaly dispatch the call to the engineer. I get messages like not in record set, urm, record source and it keeps looking for queries like extended customer...

Hi I am having trouble customermising a database template, i have changed the fields that i needed and got rid of one that i did not but for some reason it will not work. can anyone help

Hi can anyone Help with the following. All I have to explain is the following. One branch has one region Each Branch has two departments Fire & Intruder Each Department has there own set of engineers IE Intruder and Fire Engineers Each Branch has there own service Manager And each...

Ok this is what i think is correct 1st Table Eng Engineer ID Engineer Num Eng Commens BranchID Table Branch BranchID Branch Name Region CovEng table Cov EngID Cov Eng Num Comments Telephone Number Branch ID