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