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 IamaSherpa 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. DONJAMES

    Searching other entities via a form!!!

    Thanks for your assistance but there are a couple of things I want to check... You're right about how the tables and entities are set up, what I'm not sure about is the coding! You wrote: UPDATE EQUIPMENT SET Status = 'L' WHERE EquipmentID = Forms![<name of loan...
  2. DONJAMES

    Searching other entities via a form!!!

    I have four entities: LOAN, PATIENT, EQUIPMENT and REPAIR. The entity EQUIPMENT has a status of Available, in Repair and on Loan. If on the piece of equipment is on loan in LOANS, it cannot appear in repair and the opposite for repairs - the repaired piece of equipment can't be in LOANS at the...

Part and Inventory Search

Back
Top