Hello,
I have following problem
tbl_Orders:
- OrderNo (PK)
- Date
- Customer
- ...
tbl_OrderDeails
- id (PK)
- OrderNo (FK)
- Article
- Quantity
- DeliveryDate
- ...
for each record in tbl_Orders I add many records in tbl_OrderDetails
Right now I choose articles from Combo Box filtered for Customer from tbl_Orders. Still Articles are very similar and this method is potential problem when entering data. Similar names, a lot of Articles in different color mixes to choose from ...
Best way would be to add article every time based on new modal form with Articles filtered by Customer from tbl_Orders. Potentially/ user can use filters on datashhet subform in this modal. Choose the right Article, press ok to add it to Article field in tbl_OrderDetails
I have no idea where to start with this. Please point me in the right direction.
Possible? If not what would be the best approach? Thanks for help!