Alfred Trabulsi
|
| Posted: 11/03/2002, 6:38 PM |
|
Hello:
I'm having a problem when I set relations betwen two tables on the query
builder
I have 1 Main table called Shipments and four child tables related to it:
Customers, Invoicetype,shippingCo and exportport
When I set relations from shipment to: customer,invoices and shippingco,
everything works perfectly but when I add the last table (exportport) I get
a lot of repeated values, if I remove it, everything goes back to normal.
Is there a limit to how many relations can we set or am I missing or doing
something wrong?
Thanx for your help in advance.
Alfred.
|
|
|
|
RonB
|
| Posted: 11/05/2002, 5:41 AM |
|
Hi,
Sounds like you used the wrong key to join the tables. Double klik on the
line connecting the tables(in query builder) to change the way the join
works.
If I understand right you now get all fields from shipments for every field
in exportport. What you want is all shipment fields and only fields from
exportport that are listed in shipments. I'm guessing here because I do not
know the make up of the shipments table but the join to exportports should
be:
shipments.port <->exportport.port_id
Or something like that.
RonB
"Alfred Trabulsi" <atra@intelexis.com> schreef in bericht
news:aq4miv$hgu$1@news.codecharge.com...
> Hello:
> I'm having a problem when I set relations betwen two tables on the query
> builder
>
> I have 1 Main table called Shipments and four child tables related to it:
> Customers, Invoicetype,shippingCo and exportport
>
> When I set relations from shipment to: customer,invoices and shippingco,
> everything works perfectly but when I add the last table (exportport) I
get
> a lot of repeated values, if I remove it, everything goes back to normal.
>
> Is there a limit to how many relations can we set or am I missing or doing
> something wrong?
>
> Thanx for your help in advance.
>
> Alfred.
>
>
|
|
|
|
|
|
