Relationship problems

[Kicker3]

Help:

I cant figure out what I'm doing wrong. It's a simple solution but my simple mind wont let me get it to show all customers in the shed layout portal. I think the line Item TO is unnecessary. Please tell me what I did worng.

Thank you again

StorageSheds.zip

[CobaltSky]

Hi Kicker3,

You have your relationships set up as:

CustomerID = LineItemID = ShedID

In the normal course of things, an ID field is uniquely associated with the entities that are stored in the table in question, without reference to anything else, so relating the primary IDs of different tables in this way seems unlikely to produce anything useful.

However, that aside, if your aim is to show all customers in the portal, then you should establish a relationship from Sheds to Customer which uses a Cartesian Product operator. The Cartesian join operator is represented by an 'X' symbol in the relationships dialog and establishes a relationship in which all records in one table are related to all records in the other.

[Kicker3]

Thank you for the reply