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...
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!
- You can make multiple entries in your "locations" table if you have 2 different Sam's Clubs that you go to. Again... watch those videos.
- I guess that I just don't understand what to do. Everything that I tried doesn't work for what I wanted it to do. It doesn't fill the boxes that I showed you. Looks like I will have to get help in person with someone that knows what to do. Thank you for your time and have a great day.