Portal with repetitions

[gregorytan]

Hi

Need help I create a layout call Portal test with 3 field in my record call E1, B1 and Qty1 and all this 3 field had the repetition of 5. I also create anther layout call Protal report and using the 2 portal call Binding PB and Binding Saddle to show my B1 product. But I get the same data for both Protal. I attach file for you to take a look

Thanks

gregory

Portal_Test_copy.fp7.zip

[LaRetta]

Hi Gregory,

I have no idea what these repetitions represent but I can assure you that you will continue to have problems if you use repetitions to hold data. You cannot retrieve data from repetitions for reports. Each of these 5 repetitions should instead be a single record in a related table. This new related table should have the three fields you've.

If you need help understanding how to properly structure your solution, there are many wonderful people here on Forums that will help you get set up correctly. Your base structure is the most important. I cannot tell (by your small example) what you are creating; it seems similar to Invoice, LineItems & Products. Can you explain a bit more?

LaRetta

[gregorytan]

Hi LaRetta

Thanks for you reply.

I'm working on a Job Plan(Portal test). When we receive a Job, sometime if have a few edition and all this edition have difference Binding Style and Qty. I need to collect all same Binding Style into one table by using the portal. I have do some change on file like what you suggest, but I'm stuck on the portal

Thanks

gregory

Portal_Test_copy.fp7.zip

[LaRetta]

Hi gregory,

I still don't understand what the various entities represent but I will assume there is a Job (represented by a Jobs table). And a job can have several sales (represented by a Sales table). This Sales table is comprised of multiple Editions (which are like Products, indicating the Binding type and quantity).

You would view the products for a job from all sales in the portal - or via a report (not included in the sample file attached). If you select the Binding (yellow) global field, it will filter the portal. I decided not to create a report at this time because I'm unsure if I'm even creating what you want. I still need more information explaining which each entity (table) represents.

But what I wanted you to see is that the Editions should be records instead of fields. By having them records, you can add an unlimited number of them as 'products' and also an unlimited number of them in the sale. When they are fields, you will constantly be adding them to your field definitions (whether as multiple fields or repeating fields) and it will be a nightmare for you.

Understanding how relationships work is critical to good design. You will notice every table has its own uniqueID. And then you put this ID into other tables when you want to relate them.

Portal_Test_copyREV.zip

[gregorytan]

Hi LaRetta

Thanks for you reply and info.

I had see the file and had some idea to change my layout. Will come back to you again. Thanks again.

Cheers

gregory

[gregorytan]

Hi LaRetta

Let me try to explan again what i try to do. I create 2 Layout, One call Job Plan and One call Job Process monitor (Job Report).

We start on the Job Plan, every Job is one Job plan and one sale. On the Job Plan we have Job No, Title, Customer, Book Trimming Size, Edition, Binding Style, Order Qty, Job Processing and etc. But a lot of time they can be a Job with a few edition, Binding Style and Order Qty. When we said Edition here is that the book can have different Binding Style like Saddle Stitch, Perfect Bound. For Order Qty can have different Qty for differ Binding Style. You can see how it look on the file. Edition data can be country, language or other is not fix.

On the Job Process Monitor Layout is to monitor my job progress, I try to using Portal to show my Binding Style. eg. Job that for Binding style : Saddle stitch were appear on the Saddle stitch Portal to gather with Qty and Job that for Binding style: Perfect Bound were appear on the Perfect Bound Portal to gather with Qty. When select Job Completed on the Job Progress field, the job were not appear on the portal. Now the problem here is that if Job have more than one same binding style, only appear one.

I attach another file

Thanks

Cheers

gregory

Portal_Test_REV_greg.fp7.zip