Calc? Lookup? What is this?

[customfamily]

Hey guys,

I have 3 tables.

Jobs

Worksheets

People

I link a worksheet to a job.

I link people to the worksheet.

People on a worksheet may not make it onto the job so they're not linked to the job.

I display job name at the top of the worksheet by placing the jobname field from the job table at the top of the layout.

I want to keep that jobname there for all the layouts, including the people's layout. The reason i can't do this is because the worksheet layout is displaying data from the people table and isn't directly linked to the job table.

What field do I have to create that would be stored in (i assume) the worksheet table, that will contain the job name or ID number? So I can display that info on the people's layout, even though they are not directly related to the job.

Thanks so much, any and all input is greatly appreciated.

Best,

Rob

Edited August 12, 2010 by Guest

[bcooney]

What kind of data is stored in a worksheet record? Is it serving as a join table between Jobs and People?

It does not seem that you have any join tables, and that you need them.

When you say "link" I assume that you mean "relate". How are you relating these tables?