How do I link the table 'orders' to a list of artikels?
I want to send an order to my supplier.
I have a table of orders and a table of order items.
I will choose the items I need from a list of articles.
I do not want to enter all articles manually. In your example of invoices I see a formula.
How can I link those tables so that I can choose the items from the table of articles in the table?
And which formula should I need for that?
3 replies
-
Have a look at the template "Inventory". This contains orders.
Birger
-
I have made the same connection between the tables but it doesn't work in my database.
I need to copy 4 fields from the product table too the order and make a sum of the total qty.
I don't know why it doesn't work by me.I like to switch from Filemaker to this app and the orders are very important too me
-
Yes! I just find out how it works.
I need to relate each field to a field with the related artikel table. That means write in each field the formula e.g. name.name
Now it works.
Content aside
- 6 yrs agoLast active
- 3Replies
- 2456Views