Portal Unique IDs

[worralb]

I'm having trouble with a Contact list within a portal for our Suppliers (ie having multiple contact for each supplier complete with name, nbrs, email address etc). I have an ID field that is set to create a serial number and increment by one for each entry. The relationship is set between the portal ID and portal ID on the parent Supplier entry.

My problem is that each entry within the portal has the same ID number (although if I enter ten entries into one supplier, the next portal entry in another supplier has a serial number eleven higher than the previous)>

Not sure if I have explained this well and I'm sure it's simple, but I am complete numpty. Please feel free to ask Qs.

Thanks

Barney

[mr_vodka]

Make sure that the ID field on the portal is from the same table occurrence as the one used for the Portal relationship.

[worralb]

Thanks for your swift reply. There is only one occurence of the table, which bears the relationship. The ID that I use to link the relationship is a "Contact Line Item ID" on each table (Supplier and Supplier Contact Line Item), whose sole role was to link the two together.

Maybe I'm missing something. Should I perhaps have a linking table too (ie on table to hold the data, and another to display it? It seems over-the-top, but I am a novice.

[mr_vodka]

You have something close to the following correct?

Table Supplier

pk_SupplierID (auto-enter serial number)

Table SupplierContactLine

pk_SupplierContactLineID (auto-enter serial number)

fk _SupplierID

relationship

pk_SupplierID --> fk _SupplierID

[LaRetta]

I'm not crazy about stepping in when John obviously has nailed the proper configuration. But it's a seriously potential error which most new FMers fall into.

The relationship is set between the portal ID and [color:green]portal ID on the parent Supplier entry.

You should not have the portalID in the parent at all but rather the other way around!

[worralb]

I have seen the light. Thanks to everyone for their help. Schoolboy error! :