I have an inquiry form with many suppliers. I want to use the checkbox to select the supplier’s name from “Suppliers :: SupplierName” for each inquiry so that the supplier’s name can be displayed within the portal. I want to use it to enter more information such as “Quo date” and each inquiry has its own supplier(S). Could anyone help me and tell me the about relations? Thanks

James

Checkbox.zip

Please clarify what you are trying to achieve.

Sorry, I didn't explain what I am trying to achieve well.

I want to add the suppliers quotation date for each inquiry inside the "Supplier(s)" tab control and each supplier has its own "Quo Date" related with different inquiry.

For example, InquirySN SN-1 has two supplier (A Supplier and B Supplier). When I click on A and B supplier, I can add "Quo Date" inside the supplier(s) tab control portal row and when I change my inquiry to InquirySN SN-2, I can still input the different quo date for each supplier related with InquirySN SN-2.

One inquiry --> many suppliers --> many quotation date.

Thanks

You cannot create records by selecting a value in a checkbox field. You need to use a portal, and create records there by selecting a supplier in the last portal row.

NotCheckbox.fp7.zip

It is always awkward to do "one to many to many" on one layout. Because you can't make a usable "portal within a portal" for data entry in the last "many". What you can do is to select one of the first "many", then create/edit its "many" in a second portal.

In this case you'd select one of the many inquiry-suppliers, then show the selection above the 2nd portal, which is the inquiry-supplier-quotes.

I suppose you could do the above quotes in a separate tab, but I think that might just be more confusing.

Inquiries_fej.fp7.zip

Thanks for your help, I was confused by the check box function. Your solution is very useful.

Best Regards,

James

Thanks for your excellent example, I have learned a new skill and concept from it. I really appreciate it.

Best Regards,

James

Could you please help me solving my problem with your solution? I have been trying to solve it for a long time, but I am still have no clue so far. with your solution, you did not use the globe storage function and it works very well. I got a solution from a nice person. He uses the globe storage function to solve my problem, but when I add a new record, it just shows the last record until you push the switch bottom. Please help me again with one to many to many relation again. I appreciate. Thanks.

PS: Could you please explain the Set Field function to me a lot bit, I am so confusing about it.

Best Regards,

James

Question-_one_to_many_to_many.zip

1213791037-One_to_many_to_many.fp7.zip