Relationships

[Mike]

I have a Table, tblOne with a primary key, TableKey.

i have a second table, tblTwo with a primary key, TableKey.

these fields are related through the TableKey field. They are a one to one.

This was done because the first table has data that shouldn't change, but
the second table will contain calculated data that will change.

My question is this
Is there a way to access information from tblOne, through tblTwo within the
same recordset? Such as ID3 start date? where ID3 is a priamary key for a
recordset, and startdate is a field in tblOne. So that i can then calculate
the length of time between the current date and start date to store in tblTwo?

i know you can open up both tables, and while in tblTwo, pick out the
Primary key, and do a search in tblOne to get the recordset. and then
calculate from there, but with the tables being related, i thought there was
a way to not have to do that.

Thanks

 

[Jeff Boyce]

Mike

I may be missing something...

If you are saying that the ONLY thing stored in your tblTwo is calculated
values, then why?! A query can (and usually should) be used to generate
calculated values. This way, if a value in tblOne were to change, you would
not have inconsistent data in your calculated values -- every time the
(replacement) query runs, it calculates current values.