Am I going about this the wrong way? I don't think so!

[liltbrockie]

Hi there... I wonder if some kind soul could have a look at the attached file.... http://www.sendspace.com/file/7o6ed8

 

You will see some records representing Suppliers.

There is a yes/no to denote if that Suppier is an alternate supplier for the goods.

I am trying to make a relationship that will let me say for example that The goods from Supplier Franke are also available from supplier waterline

So I have a portal that shows a list..for each supplier, of all the possible alternate suppliers and I want to have a tick box that will let me say YES this alternate supplier can also supply the goods.

But at the moment the tick box is not working as intended because when you go and look at other makes the tick box is the same for all of them!

How can I create a relationship that will let me have independent control over that portal list?

[Lee Smith]

You should attach your file here.

 

I don't understand the link you provided, it took me to a commercial site where it appeared to be asking for money?

[liltbrockie]

Its not letting me attach ( Error No file was selected for upload).... sendspace is a pretty standard way of transferring files...

[bcooney]

Well, on each Product Form, I would imagine that you have a portal of Suppliers (join table btw Products and Suppliers).

 

In the Product record, you could capture the ID of the primary supplier Product::_kF_SupplierID_prim.

 

Any supplier that appears in the portal is by definition an alternate supplier for the product.

 

Often, costs, discount levels, etc., are also included in the ProductSupplier join.

[Lee Smith]

Its not letting me attach ( Error No file was selected for upload).... sendspace is a pretty standard way of transferring files...

Follow the steps using "More Reply Options"

If you tried to attach a file, it didn't make it. The process is rather easy, if you follow these steps.

Step 1

Find the file on your hard drive, and zip it.

Step 2

Do not use the Quick Reply, BUT instead, choose the More Reply Option 

Step 3

Click on Attached Files and this will take you to your hard drive to locate your file that you want to attach and that you previously zipped. Select the file, and then click Attach This File, and then click Add Reply.

 

If you have a problem, let us know, This is what a moderator is for.

Sendspace is NOT the standard way here. Attaching your file here eliminates the problems.

If you want to discuss this further, contact me by Private Message.

[Vaughan]

I'd be doing this from the Goods perspective. Create a calc field in Goods that concatenates all the Supplier names together, comma delimited. Then display this calc field in the portal in each supplier.

 

With this method is that there is no way to stop the current supplier's name frm appearing in the list. This may not be a bad thing: stopping the current suppler's name from appearing in the list is complex and most likely quite computationally intensive.