Forum Discussion
Access Relationship
How can I set up something where I don't have to keep typing the information over and over?
Here is what I am talking about:
Entry Title
POC
Phone
Address
Mileage
I need all of these to be combined as a group or relationship. Not sure what you would call this?
Can you help me out with this?
- Can you give us a little context? What is this for? Why are you typing the same data over and over again? If the data is coming from, say, a customer, then you would only need to select the customer using a combo box and his info could be copied over or at least referenced by a relationship.
See:
https://599cd.com/RelationalCombo
https://599cd.com/DLookup
https://599cd.com/AfterUpdate
Richard Rost
Access MVP 2014-15
AccessLearningZone.comI save my store receipts and mileages. If I go to Sam's Club I type the information in and save it.
This is an example of what I use. If I go to Sam's club 8 times a year I have to put the information in 8 different times. I also put other places in as well. Let me know if this helps you?
- OK. I would suggest setting up a 2nd address for your locations. This way you would then pick Sam's Club from a list, and the category, phone, address, and any other fields you want (not sure what POC is... point of contact?) would automatically populate from that table. Then all you have to do is type in the transaction amount and mileage. Watch those videos I suggested earlier.
- I used the basic template in Access called "Desktop Business Account Ledger". In the Entry Title, I put the store Name and I want the POC, Number, Address, and Mileage to autofill when I enter the Entry Title. I hope that this helps you out! Let me know if I need to give you any more information? Thank you
