I'm stumped on coming up with a way to change the dates in 2 global variable tables.

Table1 has fields called gStartDate and gEndDate

These 2 fields help define the range of records I want to relate to from Table2 and Table3. That's not where the problem is. That's working fine.

I want Table4 to hold the user entered variables to define the various reports and layouts, etc. I want to be able to enter a date in a field in Table4 -- Table4::StartDate -- and have that date go through to all the records in Table1 and populate (?) Table1::gStartDate.

Now, I can go into the tables and change the values of the global variables but I really don't want my users to.

I've tried everything I can to get the value of Table1::gStartDate = Table4::StartDate to no avail. I've tried calculations, look ups and I don't know what else.

Any ideas? Have I made my problem clear?

Thanks

Christopher

Have I made my problem clear?

Not really. If gStartDate and gEndDate are global fields, their values only need to be changed once (a global field has the same value for all records in the table).

If you want to move the start/end values to another table, you can change gStartDate and gEndDate to unstored calculations, e.g. cStartDate = Table4::StartDate. However, this will require a relationship between Tables 1 and 4.

It's not quite clear why you need to do this, when global fields can be accessed from any table/layout, without a relationship.

comment

You did it again. Now that I know the answer I feel my question should qualify for the dumbest question of the day award. I knew it was easy.

You're right. there's no reason for the relationship between Table1 and Table4. (at this point) I just put the global fields in the layout I wanted and it's working great. super. thanks again.

Christopher