Originally Posted by
TechKEYS
I was not sure which category to post this question, so "access" it is.
This question is revolved around Design, Form, Subform and possibly some coding.
3 Tables - tbl_People, tbl_Pay, tbl_Schedule
tbl_People has ID fields that join the other tables
I created a form for tbl_People - with 2 buttons to open subforms
A subform for tbl_Pay & tbl_Schedule
All works fine when viewing a Person, I can click on my button for Pay and see that persons pay; same with schedule
Problem:
if a Person does not have a Pay Record or Schedule Record yet, my situation either produces an error or new record for the two related tables.
If tried some variations of coding to make it work without success.
Wish list:
I want to be able to see a person, IF that person does not have a pay scale yet, or a schedule yet, I want to be able to "Choose/Select" an existing record from those tables not create a new one, then the one that was selected now be part of the Person Table/PayID for next time the person is displayed in the form.
Working Example:
User will pull up "Bob"in a form; Bob has an associated Pay & Schedule Record, User Click said Button and display the relevant Date - This works as it should.
Non-Working Example:
User will pull up "Phil" in a form; Phil does not have a Pay &/or Schedule Record, I would like the User to be able to "Select" an existing Record from those tables where the ID's will now be part of that persons "People" Record for the next time someone pulls them up.
Design: I design the table structure this way because a "Person" pay scale can change frequently as schedule, so I want to keep the history of say Week 1 where Bob worked for $8 and 1st Shift; but Week2 he was a supervisor for $15 and happened to be on 3rd shift.
I would take design comments or just a fix to my Wish List listed above.
Much, much thanks