Hi all,
I have good experience with Excel however it does not cater for everything I need to do and as such ahve recently ventured into access.
I have created a database that allows a user to enter data about damages on inbound loads to a warehouse. They enter the case ID, Haulier, Supplier ..... bla bla bla other boring information. They also enter the damaged items by product number and quantity. As I don't know the number of unique items that can be damaged, as many as 30 or 40 different product codes can be damaged per shipment I have created another table that relates the Case ID to each damage. Rather than creating a load of fields such as damage1 damage2 etc etc.
How this is making sense so far.
I have created a form with a subform that allows the user to enter all the information about the load and then the subform at the bottom in datasheet form so they can list all the product codes and quantities etc.
This form works fine, got some macro buttons and everything is looking fab.
However I need to create a form that allows the user to enter a case ID in a box, press a button and it pulls up all the information, including the damages for editing.
I've looked around and people suggest drop-down boxes etc but with over 1000 cases so far and more to come searching in a drop down list is a bit silly.
So I'm completely stuck on how to get started with my "Edit a Previous Case" form.
Any help would be greatly appreciated. I'm sorry its so long I just wanted to make sure I gave enough detail. Any other questions then please ask!
Many thanks,
Matthew
I have good experience with Excel however it does not cater for everything I need to do and as such ahve recently ventured into access.
I have created a database that allows a user to enter data about damages on inbound loads to a warehouse. They enter the case ID, Haulier, Supplier ..... bla bla bla other boring information. They also enter the damaged items by product number and quantity. As I don't know the number of unique items that can be damaged, as many as 30 or 40 different product codes can be damaged per shipment I have created another table that relates the Case ID to each damage. Rather than creating a load of fields such as damage1 damage2 etc etc.
How this is making sense so far.
I have created a form with a subform that allows the user to enter all the information about the load and then the subform at the bottom in datasheet form so they can list all the product codes and quantities etc.
This form works fine, got some macro buttons and everything is looking fab.
However I need to create a form that allows the user to enter a case ID in a box, press a button and it pulls up all the information, including the damages for editing.
I've looked around and people suggest drop-down boxes etc but with over 1000 cases so far and more to come searching in a drop down list is a bit silly.
So I'm completely stuck on how to get started with my "Edit a Previous Case" form.
Any help would be greatly appreciated. I'm sorry its so long I just wanted to make sure I gave enough detail. Any other questions then please ask!
Many thanks,
Matthew