Adding multiple products to one order (Model-driven app)

[Juul]

Hi All

I have following tabels:

- Account

- Product

- Order

I would like to the following in my order tabel

- Connect one Account (lookup), done

- Multiple products, fail

How can i add multiple products to my order?

Thanks, 

BR

Juul

[Mira_Ghaly]

@Juul 

• Is your tables custom or the out of box tables?
• What is the issue you are facing adding multiple products the relationship should be 1:N between order and products or more better it should be through a custom table in case you need to add more info. about order and products but it all depends on your business scenario.

[dpoggemann]

Hi @Juul ,

I would recommend adding another table called Order Line that would be a N:1 to the Order.  This table would contain a lookup to the Product entity and would also have things like quantity, price, tax, and other fields that would be tied to the order line for that specific order.