User Profile
_brunoga
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
MS Access Many Junction Tables - Design Advice
Hi everyone, I hope everything is safe at your side. I'm trying to figure out in a model of relationship that could work for my case. Here is the situation: I have a tbPurchaseRequest that will have a tbPurchaseRequestDetails with the items' list (coming from tbMaterials). In one purchase request, I can have up to 3 Suppliers (stored in tbSupplier). The prices changes per supplier for each request, so, I need to capture the price for that specific request. Here are my doubts: 1. Where is the best table to capture the quantity requested and the price information? 2. What is the most logical way to organize this? Any advice?Solved2.3KViews0likes9Comments
Groups
Recent Blog Articles
No content to show