Inventory Datebase

[vugar]

Could you help me please with construction inventory database .
Can you say your opinion about the database? Whether it is built?
In the "Asset Info" input device must be lower than "Purchase". Can it be done?


In the "Purchase" will be introduced all the equipment, and in "AssetInfo" will be shown on who or what the project was issued from the warehouse.
In the form of "Equipment List Main" page "MainPurchase" AND "MainAsset" whether you can make so that the "ItemID" when I choice it showed only the equipment that belong to category that shown on the top....

[orange]

Is this a continuation of https://www.accessforums.net/databas...ase-44111.html ?
If not, could you tell readers how they relate? What have you done?

[vugar]

In attached file shown my inventory database.

[vugar]

In attached file in the form of "Equipment List Main" second page "MainPurchase" and third page "MainAsset" could you please in the "EVENT" write rule that when I select the "ItemID" showed only the equipment that belong to category that shown on the top.

Thank you.