Forum Discussion

lee5010's avatar
lee5010
Copper Contributor
Jan 22, 2022

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?

access
    • lee5010's avatar
      lee5010
      Copper Contributor
      Jan 22, 2022

      ComputerLearningZone 

       

      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?

      • ComputerLearningZone's avatar
        ComputerLearningZone
        Brass Contributor
        Jan 22, 2022
        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.
    • lee5010's avatar
      lee5010
      Copper Contributor
      Jan 22, 2022
      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

Share

Resources