Database Check

[dfwcomputer]

Could somebody please check over my database, it is finished and just would like some last minute Input.

Click Here

Any Ideas would be greatly appreciated.

Thanks,

 

[dfwcomputer]

Thanks for your reply,

Machine form: Sort the parts list

Do you mean sycronized combo's if so what's the best way to go about this?

All the parts are known to us by part number as there really arn't that many.We use MYOB for our main buisness stuff this is mainly a db to have reminder's to allow employee's to start the db every morning and know what services they have to do that day. did you schedule a job and restart db to see the effects.Does this clarify or do i still need to change it.

Sales: Should be form/subform and have search for customer.

Service: add search and sort parts list.

could you clarify these a bit, sorry still learning access.

Customer Details: Has report header but no page header. Way too spacey. Header information is repeated for each customer. Report should be reformatted as a simple list.

Reports are one thing i am having real trouble with i originally wanted a form, where you have to combo's (one for customer's and one for machines)you would then select a customer and that would updates the machines combo to show all the models that customer has in case they have more than one machine. upon selecting the machine it would display a report showing the customer's details and the model of the machine along with the required parts to complete that service. {could be related to relationships as to why i am having trouble with this, or maybe i just have not got a clue what i am doing.)

Customer Phone List: I like it

Got this from northwind, i liked it also when i first saw it. Might be good if i could intigrate this in with the reminder's form for employee's so that when they get a reminder they good click a command button to display this and look up customer's address and phone details to organise the service on there machine. What do you think?

I have included the relationships, is this what you meant or have i gone drastically wrong.


Thanks,

 

[dfwcomputer]

Thanks got it now,

Any comments on the rest?

 

[dfwcomputer]

please, please please help as i am totally stuck

 

[dfwcomputer]

i don't kinow everything i seem to do when trying to get my forms setup does not work i think because i don't have the relationships right?

 

[dfwcomputer]

restarted db as the old was quite a joke!

Ok got it pretty close just need some help relating tblService & tblServiceParts any ideas?

To me it looks pretty good and seems to work pretty good entering data through the tables. all the expected results show up.

 

[dfwcomputer]

All changes done, Thanks

As you have probably seen i have look ups in the tables via query do these look right or is the an error?

One trouble i keep coming across if i want to look up the details of a customer in the sales table it wants to input it as the customerID number instead of the customer's name, this is why i have used the queries.

Thanks

 

[dfwcomputer]

i have included the new db with the relationships set up now? don't know how i missed that last one!

2. I NEVER use lookups in the table definition. This causes insurmountable problems when working with the table or queries based on it in VBA. I create queries that join to the lookup table. That allows me to select the ID and/or the text value from the lookup table.

there is now no look up's at all if you could show me an example it would be much appreciated.


thanks,
Dean

 

[wazz]

Cascade Delete

i notice you have Cascade Delete Related Records checked for the table relationships. i think if you keep that checked, then if you delete a customer, for example, you will also delete the sales records for that customer. same with employees, i believe: if you delete an employee they also will be deleted from the sales records and/or service records - wherever their name shows up.

perhaps someone could verify this. - w

 

[dfwcomputer]

Posted By: Pat Hartman
an example of what? A query?

What I meant was I left all the relationships set up but I also had queries set up e.g tblCustomers you could select StateID drop down and the query inputs the state you select. instead of the StateID number. the database now has no queries and was wondering if you could setup say tblCustomers & tblStates . so I can learn what to do.

(e.g should tblCustomers have a dropdown box for selecting the state or should it be left as is and use forms and queries to set this up.)

Thanks,
Dean

 

[dfwcomputer]

so if your not here to help what are you here for?

and if you take the time to explain a bit better instead of being so abrupt i would be able to do it my self! but then again if i could do it my self i would not be asking for help.????

And you wonder why i started another post! with a reply like that. Not everything is black and white there is a grey area,, so come on over there is plenty of room!

Becoming a moderator for a specific forum is usually rewarded to users who are particularly helpful

Maybe you should think about this?

 

[wazz]

there is a very fine line between helping and doing. this applies here and everywhere else in life. (look at the world). and i think it may be more difficult than some people realize to be a helper. it is important to step back now and then to let things sink in before doing more; or before asking for more. the answer is not always there in front of you, but, often, it is.

 

[dfwcomputer]

Are you getting paid to do this work?

Do you think i could get paid for this work?

my simple qwuestion is should i have drop down boxes setup in the table or should i only have relationships setup and use forms.

You are confusing helping with doing

Explain to me then how doing something for somebody isn't helping them.
e.g changing a tyre for someone that can't.

If you teach a man to fish, you feed him for life.

exactly setting up one table would have enable me to study it then i could always do it for myself!

It all comes down to your attitude, if you would simplify your posts so that people with not very good understanding of access could understand i might find it a little easier,

Instead of No i can't This is abrupt un-warranted and is just not the way you help people. There are 100's of way to help somebody, but it is your poor choice of words that aggravate me.