R
rmoule
Using Access 2007 but need to save in Access 2003 format to share the database.
I want to create a section of an existing database with a fixed total number
of various assets, where I can then assign quantities of these assets to
'locations' and also to 'case numbers'. Location and case number need to be
seperately assigned and assets can be in both a 'location' and a 'case
number' but not in two of the same. Location, case number and asset type are
predefined in seperate tables with other information attached.
Basically i want to be able to say:
i have 10 of asset X
3 of asset X are in location A
7 of asset X are in location B
5 of asset X are in case C
5 of asset X are in case D
All of these values need to be editable at any stage.
Any help would be greatly appreciated. Please bear in mind that I have
taught myself how to use Access and I am certainly not a programmer.
Thank You
I want to create a section of an existing database with a fixed total number
of various assets, where I can then assign quantities of these assets to
'locations' and also to 'case numbers'. Location and case number need to be
seperately assigned and assets can be in both a 'location' and a 'case
number' but not in two of the same. Location, case number and asset type are
predefined in seperate tables with other information attached.
Basically i want to be able to say:
i have 10 of asset X
3 of asset X are in location A
7 of asset X are in location B
5 of asset X are in case C
5 of asset X are in case D
All of these values need to be editable at any stage.
Any help would be greatly appreciated. Please bear in mind that I have
taught myself how to use Access and I am certainly not a programmer.
Thank You