a beginners question...

Powerdog

Board Regular
Joined
Oct 6, 2004
Messages
50
I looked through the search and tried to use generics but I couldn't find any answers... So I decided to to post this question... (remember ... bigtime beginner on Access)..
I created just a simple database with two tables...

First one has:
firstname
lastname
address

Second one has:
payrate
date
hours

just trying to keep it simple to learn...
My question is, after I created a form to enter employee's first name, last name, and address (three of them (just to learn))... then created a second form to put in pay rate, date, and hours... I enter it all in totally fine... but then when I go back into the form to add payroll for the same three employee's, it over writes everything.... what am I doing wrong... because I want it to list all the dates that I put in there... for later (reports)
Thank you
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Hi, it looks like there is no link between the tables. For two tables to be linked they need a common field. If you are very new to Access then you might want to have a read of someone online material such as this to help you get started.

HTH, Andrew. :)
 
Upvote 0
Thanks for the links... I wnet and read them and also fixed what I was trying to learn... Thanks again
 
Upvote 0

Forum statistics

Threads
1,221,828
Messages
6,162,215
Members
451,752
Latest member
freddocp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top