Mother_weaver
New member
- Local time
- Today, 03:22
- Joined
- Dec 27, 2019
- Messages
- 9
The purpose of this database is to collect information from contractor payments for members hourly work and track it for their future benefit tracking
I am attaching a sample of my database which only consists of 3 tables currently. I need these tables to talk through an entry form I will create once I get my relationships correct. List of what I need these tables to do is below:
contpay is getting its data from an entry
the entry form will have all the fields from this table other than the ID field
when the Acct# is entered it should match it to the SSN field in the MEMlist table and show it on the entry form to confirm it is the correct individual
the entry form will also obtain the contno which I would like for it to go to the cont table and get the contractor name and display it on the entry form (TRULY driving me CRAZY!!!!) Really have NO CLUE how to make this happen captain!!!
Once I can get these tables to talk I would like to create a dashboard, which I believer I can do, so the user will never access the raw data. it will also develop reports from the contpay table which I also believe I can make happen!
ANY help is greatly appreciated!!! I believe this will be really easy for yall go getters!! Thanks in advance for any and ALL help!! Yall are amazing!!
:banghead::banghead::banghead:
UNSURE HOW TO ATTACH THE FILE
I am attaching a sample of my database which only consists of 3 tables currently. I need these tables to talk through an entry form I will create once I get my relationships correct. List of what I need these tables to do is below:
contpay is getting its data from an entry
the entry form will have all the fields from this table other than the ID field
when the Acct# is entered it should match it to the SSN field in the MEMlist table and show it on the entry form to confirm it is the correct individual
the entry form will also obtain the contno which I would like for it to go to the cont table and get the contractor name and display it on the entry form (TRULY driving me CRAZY!!!!) Really have NO CLUE how to make this happen captain!!!
Once I can get these tables to talk I would like to create a dashboard, which I believer I can do, so the user will never access the raw data. it will also develop reports from the contpay table which I also believe I can make happen!
ANY help is greatly appreciated!!! I believe this will be really easy for yall go getters!! Thanks in advance for any and ALL help!! Yall are amazing!!
:banghead::banghead::banghead:
UNSURE HOW TO ATTACH THE FILE
Attachments
Last edited: