I have 4 tables:-
| Sales Order | Sales Order Details | Purchase Order | Purchase Order Details |
|---|---|---|---|
| Order Date | Sales Order Id (Ref of Sales Order Table) | Order Detail Id(Ref of Sales Order Detail Table) | Purchase Order Id(Ref of Purchase Order Table) |
| Sales Order Id | Order Detail Id(Unique Id) | Purchase Order Id(Unique Id) | Purchase Order Detail Id(Unique Id) |
| Customer Name | Product Name | Jobber Name | Product Name |
| Qty | Qty | ||
| Jobber Name |
Now I want if I submit any Sales Order and then it will automatically fill the Purchase Order Detail Form with the helping of “Sales Order Details Table Jobber Name”. I can’t use formulas because sometimes I need to fill Purchase Order And Purchase Order Detail Form without Sales Order And Sales Order Detail Form.