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 derfloh 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. 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)

    Hiya Thanks for your reply, glad to know im heading the right way... What do you mean by Master/child relationship ? I cant see anything mentioning either under the options! What im trying to do is have some way to 'add' items to the sale, weither that be by another subform or on some...
  3. 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...
  4. 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