Search results

Oops . . . maybe this is better.

Lets try this again. I made some changes, for the better I hope, I would appreciate any comments or suggestions. Thanks, Joseph

I think I'm lost again. Are you saying that I need to link from ID_PhoneNumber to the primary key in the tbl_Contact? And the same thing for the three that are connected to tbl_WorkOrders? The only data I have in the database is just things I have put in to test some of the forms I had before...

I went back and reworked it some, taking your advice into account, and trying to remember what I learned in class. I appreciate any comments. Thanks, Joseph

It does help, thanks. By repeating fields do you mean a field that is also in another table? Like MechanicID in the MechanicList and Mech_WO tables or is the two Primary and Seconday Phone Number entries? Other than that (the same question goes for WorkOrders table) I understand what you are...

I am eager for someone to look at this structure and tell me how well the normalization is. Thanks, Joseph

Great. Thanks for the help. This brings up another question. I want to take that rate multiply it by a number of hours that the user types into a Hours text box, and then save that final amount to the table. What I have so far is "=[Text21]*[Text27]" I just don't know what to add after that...

Ok in making a combo box (using the wizard, I am a newbie) I chose the Last name, First name, ID, and Rate. In that order. I want the the combo box to display the Last name, and have a text box display the Rate. I figured out how to display the last name, but it dispalys the ID (which is the...