I've worked a little with Access desktop databases, but I'm brand new to Access Web Apps. I have 3 tables, Customers, Stock and Orders, Orders being the equivalent of my Master table. The idea is that Users would input an order via a form to the Orders table, selecting the customer and which stock items they want via lookup fields linked to the customer table and the stock table.
I have linked the Customer table account number field via a lookup to the Orders table and in the form based on the orders table I want to select the Customer number from a dropdown and then have the rest of the customer address fields on the order fill automatically. I will need to do something similar for the stock items as well, pick the item code and fill the description field automatically.
Normally I would just use a Dlookup in an after update event (Not sure whether that would be best practice, but it's always worked for me). But I can't use vba in Access Web App.
I'm using Access 2010 as we don't have Access Services enabled for SharePoint 2013. Googling this is telling me to use Macros but there are limited tutorials/examples and I have no idea what I'm doing and have tried a few things and nothing is working.
Can anyone help and give me any direction or tell me how I do this in an Access Web App please?