Hi, Im hoping someone can point me in the right direction. Im a freelance transcriber for a couple different transcription companies. Im also a freelance tutor for an online proofreading course. I track a different set of data for each customer in order to invoice them. I also like to keep a detailed record of how I spend all my time.
I have three main customers right now. Each is listed in a customer table. Each has their own job details table, and each job can involve multiple work sessions to complete. But thus far, Ive been tracking work sessions separately for each customer. Seems like I ought to only have one work session/time clock table with all my time-in, time-out entries, but Im not sure how to relate it to the three separate job details tables. Plus, I have other one-off customers and am bound to have different customers in the future. Ive been fiddling around with customer-specific job numbers. Im wondering if I should build an orders type database. Do I use forms for jobs and subforms for time clock entries? I can totally follow Richards videos to make everything happen, but Im stumped at the design stage.