Search results

Thanks so much for the advice sneuberg and jdraw. I've set up an append query that appends clients from tbl_excelImport to tbl_clients and it works a treat! The append query runs a couple of functions I cooked up to strip extra spaces and fix capitalisation, it is exactly what I was after...

Thanks for your help jdraw. I probably should have been more specific - this database doesn't need to store what products were ordered or any details about them. It's for a foodbank, the only thing they record is how many bags a client ordered. That standard model is useful to have in mind...

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

Thanks for replying spikepl. I see what you mean, however for the situation I'm in, users will only ever be inputting one order at a time. In reality the only reason customer details are being stored in a separate table to order details is so the customer details can be automatically filled out...

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