AnsweredAssumed Answered

Showing more than one record in layout view

Question asked by paulwatts on Feb 27, 2014
Latest reply on Mar 17, 2014 by paulwatts

I'm using Pro 13 and I'd like to show more than one record in layout view.

 

I have a table (e.g. below) with a date field and a job field (this just counts the jobs in any day - note that every day starts at Job 1).

 

DateJobStaffToolLocationMaterials
1 Jan

1

JoeSpannerHereNuts
1 Jan2SidWrenchThereBolts

1 Jan

3FredDrillSomewhere elseNails
2 Jan1SidWrenchNowhereBolts

 

I want to produce a layout (not a list) that shows all jobs for a date (e.g. jobs 1, 2 and 3 in the above table) simultaneously but I'd like to see each table record summarised in different areas of the layout (see e.g. below for 1 Jan). Note that each day could have up to 10 simultaneous jobs so there would be 10 areas defined in the layout, some populated and some not.

 

Job 1Job 2Job 3Job 4Up to Job 10
JoeSidFred
SpannerWrenchDrill
HereThereSomewhere else
NutsBoltsNails

 

Then I want to be able to view all days in list view using this layout.

 

Should I be using portals for each job? Can I show different records in each portal?

 

Is this all too much to expect??

 

Your thoughts would be much appreciated.

 

Regards

 

Paul

Outcomes