Search results

  1. J

    Importing from Excel and splitting into two tables - customers and orders

    I've been struggling with this problem for a while now, I can't get this one worked out. Database structure: i.imgur.com/VzAdlKh.png I have two tables, tbl_orders and tbl_clients. I have an Excel spreadsheet that the company previously used to store this data - a very basic setup where each...
  2. J

    Subform search box to select record - master/child field problems

    Hey folks Situation I have two relevant tables: Orders and Customers. I'm creating a big long form to enter a new order. One part of this form is entering the customer details. The customer and order are linked by AutoNumber CustomerID. I have a subform called Edit Customer within the New...
Top Bottom