This is probably the wrong forum, but there doesn't appear to be one directly related to my query. However this forum comes up frequently when searching for posts relating to MS access
I am trying to create a traceability database. I am having trouble with one specific area...
There are two tables, one which lists each device, this then has a sub table which lists all of the movements a device has made, they are related by the serial number.
The one end user has to move around multiple devices and so I have a form which allows direct entry into the movement table with a dataset view. The user first selects the batch from a dropdown menu created from the link back to the parent table, then enters the new location.
This all works fine but it has occured to me that at the moment the database is small; there are only a few items in use and therefore it is quick and easy to locate the item being moved in the dropdown. When the number of devices gets larger this will be more problematic.
My solution is that there is a flag in the parent table which identifies the devices as sold (for the intent of this post), therefore never going to be moved again and so can be removed from the dropdown list.
I can obviously create a query to list the unsold devices but I can't then use the query to feed into the form.
can anyone offer a solution?
I am trying to create a traceability database. I am having trouble with one specific area...
There are two tables, one which lists each device, this then has a sub table which lists all of the movements a device has made, they are related by the serial number.
The one end user has to move around multiple devices and so I have a form which allows direct entry into the movement table with a dataset view. The user first selects the batch from a dropdown menu created from the link back to the parent table, then enters the new location.
This all works fine but it has occured to me that at the moment the database is small; there are only a few items in use and therefore it is quick and easy to locate the item being moved in the dropdown. When the number of devices gets larger this will be more problematic.
My solution is that there is a flag in the parent table which identifies the devices as sold (for the intent of this post), therefore never going to be moved again and so can be removed from the dropdown list.
I can obviously create a query to list the unsold devices but I can't then use the query to feed into the form.
can anyone offer a solution?
Last edited:
