Converting a ProjectInfo table into an Expenses Template

[RootMason]

Hi All!

I am trying to take an old mdb database and refurbish it using a 2 templates (Desktop time & Desktop expense). Migrating over most of the data and redefining relationships seems to have worked, but I'm currently stuck on how to turn their old CombinedProjectInfo table into something reasonable in this new setup. I was wondering if any of you in here have an idea how I might take this (the old CombinedProjectInfo):


And use it in this template (Desktop expense):


I sure would appreciate any advice. Thanks much, all!

Steve Clark

[ItsMe]

Just the name, "CombinedProjectInfo" seems to imply there is duplication of data within this table. You can further complicate the issue by relying on off the shelf solutions to remedy the problem. Business rules dictated by operations and the back office create relations, not templates.