I know all these points may have been addressed elsewhere, but I cannot find them, so here is my shopping list of questions
I have a 4 tier structure for an orders database, as follows
1 Department places order
2 Order has supplier and shipping charges and lines of orders and calculated field of order total
3 Line has item code and price and calculated field of line total
4 Goods in has dates and quantities received, calculated field of balance of goods due.
If This were a spreadsheet, I could have the calculated fields auto calculate as the focus passes through them, and the Order Total on the master table can be calculated as the order is entered.
How can I do this?
Also, I would like to produce the order in its final form with the order details at the top, then the suppliers details, then the order line details in a central section, then the order totals and supplier contact details at the bottom ready either for printing or turning into a pdf for emailing to the supplier.
Do I have to custom code all of this, or is there an easy way to get the totals done at the end of each line..
Also..... I notice that if I click Inline Add 4 times, I will get 4 blank records to fill in, so I can fill 4 records at once and click Save All.
Now I want to give the order line a unique reference, in the form of 'ordernumber'/'linenumber'
but I want the line number to start at 1 for each order, so for order number PCS-235 I would like line numbers of PCS-235/01, PCS-235/02 etc
So I can set up a variable to count with and set it to 1 at the start of each new order, then Concat the order number and the variable to make the line number, but how will this work if I do multiple Inline Adds, saved with the Save All button?, do I need to find a different way of doing things?
Led Zeppelin had it right, Dazed and Confused is me ATM
Cheers for reading this, I hope you can all help me?