KuronekoOfDarkness
New member
- Local time
- Today, 15:49
- Joined
- Jun 25, 2014
- Messages
- 2
So, I've just started Access about two days ago, and I've been experimenting with some of the features and such.
Now, I'm stuck on an idea of making a form automatically fill information in the other boxes based on what I typed in a previous box.
Because, I am a new member, I can't post the images I would like to use to demonstrate my idea, but I'll do my best to explain it.
In one table, called Project_ID, there are three fields, in which the first, contains the unique key for the product. Example:
ProdID (unique key) | Product Name | Product Use | etc
In the other, I have a table called Shipping Reports, in which it contains the two fields previously stated after another unique key called ShipID
ShipID | Product ID | Product Name | etc
What I am trying to accomplish, is when I go to a form under Shipping Reports, and type in an ID in the field for Product ID, I want it to extract the information for the Product Name under the table Project_ID
Remember, I have only just started Access yesterday and I know next, to none of the UI nor coding. If you could give me an in-depth explanation (hopefully with pictures), I'd be really happy. If it's not possible, is there perhaps another way to do so?
Now, I'm stuck on an idea of making a form automatically fill information in the other boxes based on what I typed in a previous box.
Because, I am a new member, I can't post the images I would like to use to demonstrate my idea, but I'll do my best to explain it.
In one table, called Project_ID, there are three fields, in which the first, contains the unique key for the product. Example:
ProdID (unique key) | Product Name | Product Use | etc
In the other, I have a table called Shipping Reports, in which it contains the two fields previously stated after another unique key called ShipID
ShipID | Product ID | Product Name | etc
What I am trying to accomplish, is when I go to a form under Shipping Reports, and type in an ID in the field for Product ID, I want it to extract the information for the Product Name under the table Project_ID
Remember, I have only just started Access yesterday and I know next, to none of the UI nor coding. If you could give me an in-depth explanation (hopefully with pictures), I'd be really happy. If it's not possible, is there perhaps another way to do so?
