littlemiss
New Member
- Joined
- Apr 27, 2010
- Messages
- 11
Hi all,
This is my first post, so hope this makes sense.
I'm trying to combine 2 different dynamic lists into one, from 2 different data sources, but with one unique column ID ref.
eg Page 1 shows:
Staff # / Project / Hours worked
Page 2 shows:
Staff # / Project / Expenses claimed
The list of projects each staff member works/charges on can vary - just because there are hours, won't mean there are expenses and vice versa
I'm trying to create a master list on page 3 which shows
Staff # / Project / Hours / Expenses
.. but trying to avoid multiple line items, and trying to avoid messy copy/paste/sort/delete routines if possible
Is there a clever way of calling and presenting this data?
All help much appreciated, thanks!
This is my first post, so hope this makes sense.
I'm trying to combine 2 different dynamic lists into one, from 2 different data sources, but with one unique column ID ref.
eg Page 1 shows:
Staff # / Project / Hours worked
Page 2 shows:
Staff # / Project / Expenses claimed
The list of projects each staff member works/charges on can vary - just because there are hours, won't mean there are expenses and vice versa
I'm trying to create a master list on page 3 which shows
Staff # / Project / Hours / Expenses
.. but trying to avoid multiple line items, and trying to avoid messy copy/paste/sort/delete routines if possible
Is there a clever way of calling and presenting this data?
All help much appreciated, thanks!