Recent content by RhysAZ

Thanks Bob!

Scooterbug- Yes, you are correct. It's for tracking daily tasks the reps do. There are 8 tables for the task groups and 54 tasks in total. Question1: Should CategoryID,TaskID and EmployeeID all be primary keys (within their own tables) and use autonumbers? Question2: How should the...

Attempting to upload it again.

Here you go. I have "not" some of the macros so it will open correctly. If you have questions please let me know. Thanks dcb! Update- I cant see my uploaded db. Is there a way for me to try to upload it agai or do I need to post another reply?

Yanie- This is similar to what I'm looking for. However, in this example db, you cannot enter new records that have prefilled rows in the subform. Thanks for you help though. dcb- No, I am definitely not married to my design of this db. I've looked across the web for something similar to what...

Thanks for the quick reply dcb. Sorry, I didn't include all the info. Basically I asked this question because of a db I'm designing and I wanted to use an example similar to what I want mine to do. Please bear with me as I really need your help with this. My db is for Daily Task tracking for...

Hi- I would like to know how to autofill subforms rows with data when I open my main form, which will start with a new record. Example: Main form name is "Food". Subform name is "Fruit". When I open the "Food form, I want the subform field (named Fruit Name") to auto fill with various fruit...