I didn't get this part:
When I open a new record in the EXTERNAL PITCH LOG table I would like it to automatically create a new record in the DEVELOPMENT TRACKING table
What would be the content of the new record in the DEVELOPMENT TRACKING table?
IIUC, you should have two tables, Projects and Pitches, related as:
Projects:: ProjectID = Pitches:: ProjectID
With a portal to Pitches placed on a layout of Projects, you can see all the pitches made for the currently viewed project - and, if you like, you can enter new pitches directly into the portal (if you enable automatic creation of new records in the relationship definition).
i want a new record to include the fields title, date created, source (external), and date passed.
the external pitch log is a sub-table of the bigger development tracking.
so in development tracking there are only two possible sources - internal amd external.
when a pitch is external, i need to have a whole slew of new information (who pitched it and their contact info)
your question made me realize that i am being overly complicated by keeping these as two tables.
thanks so much!