Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by xskaterboy

  1. xskaterboy

    HELP WITH DUPLICATES!!!!

    Thank you so much..... The information was very helpful!
  2. xskaterboy

    HELP WITH DUPLICATES!!!!

    Thank you! I just tried it an it worked!! Now This is a very intense database that I am trying to create, can I do all my fields (about 200+) with just one table? and if so does that defeat a purpose to relationships? Or when is is a good idea to use more than 1 table? Thank you for ANY...
  3. xskaterboy

    HELP WITH DUPLICATES!!!!

    Here is the form in a nutshell: I need 3 sections; Renters info, Drivers info, other vehicle drivers info. Since section has duplicate fields like: LastN FirstN Address City Zip DOB License# etc. are all duplicate info with seperate data, don't I have to use 3 seperate tables so that the...
  4. xskaterboy

    HELP WITH DUPLICATES!!!!

    HELP!! I have a form that has DUPLICATE field names from different 3-4 different tables ie: Last Name, First Name, Address, etc. When entering the data it changes ALL the fields that have the same name! ie: Last name= Smith Last name= Johnson Last name= Shattuck .....Then they ALL change to the...
  5. xskaterboy

    FIELDS ARE DUPLICATING!?!?

    I saw a tip somewhere that to create a form, that you should use data from a query? Is this true? Also the BIGGEST problem that I have is while entering info in the fields, I have "LAST NAME" from 3 different tables (and they each so happen to be the primary key) but what ever I type in the...
  6. xskaterboy

    Multiple Tables?

    I am kind of new to Access, and I have been looking at many many samples and templates. The question I have is; can anyone give me a semi-simple answer: Is it necessary to have more than one table? Cant I just use one table and list all the fields that I plan to use, or will that screw things...

Part and Inventory Search

Back
Top