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 Rhinorhino 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: *

  • Users: eddrimmer
  • Content: Threads
  • Order by date
  1. eddrimmer

    How do I subtract 1 from a field when a record is added...

    Hi, I have a sales form and subform. Everytime the record is added, I need to somehow get the amount of stock deducted as the items are sold. Is there anyway to do this? The item quantity is stored in a number field.
  2. eddrimmer

    A complicated form... (Got screenshots + db link to help)

    Hi I'm hoping someone can help with what im seeing to be a complicated form. Basically I'm putting together a computer shops database, so far it has every function working as I want it to be but the main form, 'New Sale' is being a real hard one. The form asks the user to chose their Staff ID...
  3. eddrimmer

    Help with relationships linking

    Hi My database for a computer shop will hold details of a sale. I have a sales table which has: SalesID, CustomerID and StaffID. I need to have details of what the customer buys in another table called SalesDetails, but am not sure what relationships I will need? Ive been told the Sales table...

Part and Inventory Search

Back
Top