Can a record in one table use value in another?


I have the following tables:
Parts (up to 100 per project)

One project has many parts.
Parts are never on more than one project.

I want a due date on project that can be seen in the part table. Is there a way to use the project due date to drive a part due date in the parts table.

A person is looking at the list of parts they are responsible for making. They need to prioritize these by due date. Due date is in the project record as adding it to parts would mean doing adding that due date up to 100 times.


Yes, this is what Lookup field is for: