D
dupa
Guest
I'm new to access - I need to create an autolookup and I am lost
I'm making a data entry form that will record payment transactions for members of a club. They come in and use our facility, we give them a rate, and they pay using a chit or a member sign off. Meaning no money passes, only a sign off. the member will get billed by their club, and the club then pays us what they owe.
I need to record these transactions in order to turn a file over to the club for their accounting ,a nd then they pay my company.
It's very simple. The first table is just the transaction. It records:
Member #
Date
First name
Last name
business code
transaction amount
and notes about the transaction
there is also a unique autonumber identifier(prime key)
the second table that I got is the member database with:
Member #
Last name
First name
and I added a unique number (prime key)
I want to be able to do 2 things with the form.
1. When the data entry person types in the member # off of the sign off slip, I want the members table to be read and return the last and first names and write it to the transaction table - so you typein the number and hit tab and it populates the name field. This will make data entry fast as they are only putting in the # and the amount (they may need to change the date if it's a different date.
2. I want new members that are added for the first time to be written to the member table for future use. So the number goes into the form and because it doesn't exist, it leaves all the fields blank and the name gets entered etc. when it iss done and the person moves on, it gets saved to the transaction table and to the members table.
I keep getting stuck on the query. I don't knw what to set as the primary key I cat set upreferntial integrety as my fields have null values. I'm just stuck and do not know access well enough to know what I am trying to find.
Thanks for the help
I'm making a data entry form that will record payment transactions for members of a club. They come in and use our facility, we give them a rate, and they pay using a chit or a member sign off. Meaning no money passes, only a sign off. the member will get billed by their club, and the club then pays us what they owe.
I need to record these transactions in order to turn a file over to the club for their accounting ,a nd then they pay my company.
It's very simple. The first table is just the transaction. It records:
Member #
Date
First name
Last name
business code
transaction amount
and notes about the transaction
there is also a unique autonumber identifier(prime key)
the second table that I got is the member database with:
Member #
Last name
First name
and I added a unique number (prime key)
I want to be able to do 2 things with the form.
1. When the data entry person types in the member # off of the sign off slip, I want the members table to be read and return the last and first names and write it to the transaction table - so you typein the number and hit tab and it populates the name field. This will make data entry fast as they are only putting in the # and the amount (they may need to change the date if it's a different date.
2. I want new members that are added for the first time to be written to the member table for future use. So the number goes into the form and because it doesn't exist, it leaves all the fields blank and the name gets entered etc. when it iss done and the person moves on, it gets saved to the transaction table and to the members table.
I keep getting stuck on the query. I don't knw what to set as the primary key I cat set upreferntial integrety as my fields have null values. I'm just stuck and do not know access well enough to know what I am trying to find.
Thanks for the help
Last edited:
