Automatic replenishment of supplies based on an entered request.

[milena_mb]

Здравейте всички, разработвам база данни и клиентът иска да въведе заявки за доставки, но не иска да премине през същия процес на избиране на артикулите отново. Проблемът е, че самата поръчка е съставена от две таблици. Единият съдържа искането, а другият самите елементи. Те са свързани с номера на заявката. За доставките ще използвам и две маси една за доставката и една за детайлите. Планирам да използвам номера на заявката, за да попълня формуляра за доставка, но не съм наясно как да изградя самото събитие. Никога преди не съм правил нещо подобно. И най-важното, възможно ли е дори да се изгради такова нещо с достъп?

 

[GPGeorge]

Translation:

Hey everyone, I'm developing a database and the customer wants to enter supply requests but doesn't want to go through the same process of selecting the items again. The problem is that the order itself is made up of two tables. One contains the request, the other the elements themselves. They are related to the application number. For the deliveries I will also use two tables one for the delivery and one for the details. I plan to use the request number to fill out the shipping form, but I'm not aware of how to build the event itself. I've never done anything like this before. And most importantly, is it even possible to build such a thing with access?

Yes, this is exactly the kind of application Access handles well.

It's not clear, unfortunately, what you mean by " the customer wants to enter supply requests but doesn't want to go through the same process of selecting the items again."

Can you clarify? In English, preferably.

You might find some very useful features in the Northwind Developers Edition template here.

 

[The_Doc_Man]

Since that was your first post, hello and welcome to the forum.

Since this is an English-language forum, you might do better to learn how to use Google Translate.