update text box data to other than record source

[carpstar]

Is this possible???
I have text boxes on sub forms that have either text boxes or combo boxes on a main form as their record source. Is there a way to get the data entered in these text boxes to update to a given table even though another text is the record source, If so could someone explain how to do this.
Any help or feed back on this would be greatly appreciated.
Thanks in advance...

 

[Fornatian]

This is possible but please explain your reasoning, after all the whole point of a relational database is to eliminate duplication of data. You should be able to extrapolate the data using a query where needed.

Ian

 

[carpstar]

Thanks for the reply. You are right, I started work on a query just before reading your reply. Will post back to say how I made out.
Again THANKS
Rory

 

[carpstar]

I still need help, Let's see if I can explain what I'm trying to do. I have a table for staff hours with fields for NAME,DATE,DEPT,ID#,REGHRS,OTHRS,VACHRS,etc.
I want to populate this table by using one form with as little keystrokes from user as possible. Data will be entered at end of a work week. Form should have sections for each day of week with all fields from table in each section. When date is entered in Mondays date text box, dates for Tuesday-Sunday should automatically fill in "Monday Date+1" "Monday Date+2" etc. The NAME,DEPT#,and ID# should work similar using combo boxes in MONDAY secton. All other fields "RegHrs" "VacHrs" etc. will be manually entered in each days section.
Once hours are entered on form for each day worked for selected employee, user would clic a commit button to populate table and refresh form for ready to select next employee.
I must be going about this all wrong. As I mentioned in the initial post, I have no problem when user can enter data one employee and one date at a time for small dept, but this will be for 60+ employee with one person doing entry.
Please,any suggestions on the best approach will be greatly appreciated.
Again, Thanks to all who may offer assistance to this newbie.

 

[Rich]

Scrap the original I misread the post, seems a lot of unnecessary work entering 3000 dates a week however you do it. Wouldn't 1 table with dates linked to employees on a one to many be a better idea.

[This message has been edited by Rich (edited 04-14-2002).]

 

[Rich]

Having read the other post of yours on this subject we now find that you have 7 date fields Mon,Tues etc, that's not the way to store date related information in Access. You only need one date field, the day can be displayed at anytime from that date.

 

[carpstar]

Rich
I don't have seven date fields on Staff Hours table, I want to have seven date text boxes on one form/or if I have to one date text box on individual sub form to update the one date field on table.As the entry form exist now the user enters the date for Monday,selects employee then enters hrs in appropiate text boxes ie: reghrs,vachrs,etc..that's one record.Then enters date for Tuesday selects employee and enters hrs. and so on for entire week.I need a way to speed up entry by getting rid of repetitive steps.
Rich, your suggestion about 1 table with dates linked to employees on one to many relationship. Does this mean a table with only one field (dates)?

 

[David R]

Main table (StaffInfo) will have employee data. Subtable (StaffHours) will have its own primary Key (probably Autonumber), EmployeeID (as a Foreign Key), Date, TypeHours, and Hours (if I understand your needs correctly).
Your main form should have the employee data. That way you can insert records for one employee in series without having to find their record again. If you're entering all data for one day instead you might want a different structure, but that's not how your message read to me.
Your subform will be based on that subtable, though it doesn't need to 'show' the Autonumber PK/EmployeeID fields, just have them in the recordsource. Use the Insert Subform/subdatasheet wizard, it will make the connections properly so you only see records for this employee. Make the subform a Continuous Form, or Datasheet View.
Now you should be able to choose date, choose hours type (reghrs, vachrs, etc), and input hours, for the whole week, in moments.

Post back if you have further problems.
David R

 

[carpstar]

David, Thanks for the post. I'll Try to follow your recommendations as soon as I get the chance, which will be a few days.
We have a site inspection to prepare for so my time on this database project will be very limited until afterwards. If I'm visualizing it right this should do it. Most of what I'm doing is new to me, so it's learn as I go.You and the other Members are great with all the help, maybe soon I'll know enough to help someone out that's like I am now. AGAIN THANKS EVERYONE. My next post will be that all is working
correctly ;-)

[This message has been edited by carpstar (edited 04-17-2002).]