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!

Register Log in
  • Congratulations Mike Lewis 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. kahless

    Generating purchase orders for each supplier adding relevant products!

    Thanks for the reply. I found a work around in the end which resulted in a massive data structure redesign. It doesn't work exactly as I intended but it does the job! Ta
  2. kahless

    Generating purchase orders for each supplier adding relevant products!

    I am working on a database system for a small furniture retailer. I have uploaded a picture of the relationships because I don't know how I'd describe it otherwise! http://www.geocities.com/petehunt2000/relationships.gif I've hidden tables which aren't relevant. The StockTracker table...
  3. kahless

    How to check if data already exists in a table?

    Thanks for the quick reply. Works perfectly! Ta
  4. kahless

    How to check if data already exists in a table?

    I am trying to construct an if statement which will perform a function on a string if that string does not does not already exist in a table, so that duplicates can are avoided. I am using the code: If IsNull(DLookup("[ID]", "testtable", [ID] = IDtest)) - [ID] is the field to check -...

Part and Inventory Search

Back
Top