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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bastian

    Relationships, Lookups, Subforms

    Pssst! Hello? Anyone? :(
  2. Bastian

    Relationships, Lookups, Subforms

    Thanks so much for replying – I assumed you had given up on me for my cluelessness. *sheepish grin* I set the tables and relationship up the way you have outlined. Yay!! The invoice total isn’t a derived field – it’s just the total that I enter from the invoice. I decided it would be better...
  3. Bastian

    Relationships, Lookups, Subforms

    I’m not sure what you mean by “normalized”. I’m only trying to join on the productnumber column, which (I thought) should be a 1:m, but it’s coming up as a 1:1. Description, unitmeasurement, weight, etc. repeat in both tables because I thought I needed to do that in order to add those records...
  4. Bastian

    Relationships, Lookups, Subforms

    I’m trying to specify it in the relationship window. I don’t get any error messages, it just automatically is a 1:1, and I don't have the option of changing it. I thought that maybe it was because the data types were different in the five corresponding fields, but they're all the same. Is there...
  5. Bastian

    Relationships, Lookups, Subforms

    I am a newbie. I need help very badly. I have two tables: tblinventory and tblpartslist. I want to create a one-to-many relationship between them, and Access isn't allowing it. I have no idea why. The data types are the same, and there are 5 fields in each table that should correspond to each...
  6. Bastian

    Subform with AutoLookup Query

    I have two tables - tblinventory and tblpartslist. I would like to create a form from tblinventory, with tblpartslist as a subform, so that I can enter a list of products for each inventory record. I would like to be able to enter a product number into the tblpartslist subform, and have it...
  7. Bastian

    AutoLookup Query in Subform

    I have two tables - tblinventory and tblpartslist. I would like to create a form from tblinventory, with tblpartslist as a subform, so that I can enter a list of products for each inventory record. I would like to be able to enter a product number into the tblpartslist subform, and have it...
  8. Bastian

    A hacker put a folder on my server-it cant be deleted!!!

    The rd command seems to work here when I maked a weird dir to test.

Part and Inventory Search

Back
Top