While trying to store product specific information in a newly create db, I think I have hit a wall.
Few basic assumption and facts:
There are item parts that are used to make machines or equipment for different projects (BOM)
Each item can be part of different bill of materials or projects. Each bill of materials can have different items (many to many)..so far so good
Now an item has only three attributes. The first two attributes are the code and description (which are unique ).
The third attribute is the length (which can be different for different unit of measurement -like meter for English or foot for American) -
Code | description | length
0023 | pencil | 5(meter)
The user doesn't want the DB to do any conversion (for foot to meter or vice versa as there are situations where the exact conversion would not be preferred rather an manually adjusted input be used) ). In that case I need to do something so that when they enter in a new item - And would want to add two different values for the [length] to correspond to the two unit of measurement - they can do it
so how do I store the information about the item's length that is specific to the English and american units so that the users can put in different lengths for the same item in the DB - ?
maybe like a many to many between item and unit of measure table?
again - the item's code and description are UNIQUE to the item. Its only the measuring metric [length] that will be different for the two unit of measurement....
Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…