Tiosylanyl
New Member
- Joined
- Jul 31, 2006
- Messages
- 48
Hello,
I'm building a user entry form to help some of our field reps to use as a tracking tool for their schedules. Currently, I have the following tables:
*: Designates primary key
CA Table
CA ID*
CA Name
MCA Name
Weekly Schedule Table
Schedule ID*
CA Name
MCA Name
Year
Week #
Date
In office (Y/N)
Location if outside office
Best way to reach
Persons contacting
Planned tasks
Client visit table
Visit ID*
CA Name
MCA Name
Year
Week #
Visit Date
client ID
Client Name
Purpose of visit
Client Call Table
Client Call ID*
CA Name
MCA Name
Year
Week #
Call Date
Client ID
Client Name
Purpose of Call
Here are the questions I have before I get too far:
What would be the best way to set up relationships between these tables or, conversely, would it be better to just set this up onto one table? What are the pros and cons to setting up separate tables with relationships over setting it up on one table?
Additionally, I intend on inserting a calendar so that, depending on the date selected, the date fields will auto populate. That much I know how to do - I would additionally like to have the "Year" and "Week #" fields update accordingly without relying on user entry in those fields - is there a way to set this up?
I'm building a user entry form to help some of our field reps to use as a tracking tool for their schedules. Currently, I have the following tables:
*: Designates primary key
CA Table
CA ID*
CA Name
MCA Name
Weekly Schedule Table
Schedule ID*
CA Name
MCA Name
Year
Week #
Date
In office (Y/N)
Location if outside office
Best way to reach
Persons contacting
Planned tasks
Client visit table
Visit ID*
CA Name
MCA Name
Year
Week #
Visit Date
client ID
Client Name
Purpose of visit
Client Call Table
Client Call ID*
CA Name
MCA Name
Year
Week #
Call Date
Client ID
Client Name
Purpose of Call
Here are the questions I have before I get too far:
What would be the best way to set up relationships between these tables or, conversely, would it be better to just set this up onto one table? What are the pros and cons to setting up separate tables with relationships over setting it up on one table?
Additionally, I intend on inserting a calendar so that, depending on the date selected, the date fields will auto populate. That much I know how to do - I would additionally like to have the "Year" and "Week #" fields update accordingly without relying on user entry in those fields - is there a way to set this up?