Search results

  1. M

    Stock query implementation

    Hi guys/gals I have managed to work out a query, so when a product is selected for order, it will fetch the necessary stock level for that product into the stock table. Thing is, I use the order table credential "Phone ID" which is a lookup as a query item, so the query looks for what is...
  2. M

    Question Access 2007 link stock to product

    Feel free to move if in wrong place I need to design a database, storing customer details, taking orders, different talk plans, different phones and different manufacturers I want it so when making an order, you select the phone, and talkplan (done this already) but it also fetches the stock...
  3. M

    Make a lookup table show all fields where it is looked up (?)

    Hey I want my lookup table to show more than the initial entity in a field (think i got the right words there). As you can see I need to have more than the manuf showing so i can double check orders etc. Thanks
  4. M

    Addition of cost in a subform via lookup

    Hey I am creating an inventry system and so far so good for a beginner. I have created an ordering system, extremely basic which is getting there. I need to be able to add the total cost up to the footer of the subform which I will then use to create invoices etc. Once I have that...
Back
Top Bottom