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 com...
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.com
See:
https://599cd.com/RelationalCombo
https://599cd.com/DLookup
https://599cd.com/AfterUpdate
Richard Rost
Access MVP 2014-15
AccessLearningZone.com
- 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
I 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 do have a 2nd address, I don't know how to add this so that I can use it. I have it listed as a table listed as Company Information. What is the best way to get it to tell it where to go? POC stands for Point of Contact!
