Table Relation!!!!

Hanen

Hello,

I'm using the customer table and two others tables that I have created.
I have a customer No Field in both of my tables and when I set the propriety table relation to customer."customer No" in my first table it works but when I set the same propriety in my second table to "table 1".""Customer No. it didn't works
How can I deal with that problem, it's very urgent!!!!!

Thanks for the answer!!!

garak

What will there not work?
Will there a error message displayed or what is?

when I set the propriety table relation to customer."customer No" in my first table it works

U mean the repaltion to table customer field "No.". Field "customer No" doesn't exist in the table customer. Or is this a customized field?

Hanen

Yessss, the repaltion to table customer field "No." doesn't exist on the "customer No" field of the second table!!!!

Belias

mmmmm........does the customer code on your "second table" exists in your Customer table?
if not, what did you expect to receive instead of an error?
e.g.: if you have in your second table the field "customer no." populated with 'dskjfladsjf' value and you don't have a customer with code 'dskjfladsjf' in your customer table.

stryk

Hi!

Uhm ... I'm not sure if I understood this correctly ... :oops:

So what we have is this (if I don't err):
T18 "Customer"
Table1: There is a field "Customer No." which relates to Customer."No." and works OK
Table2: There is a field which relates to Table1."Customer No." which does not work.

Right? If this is the case, then the reason is obvious: You can only relate to "Primary Key Fields" of the referred table!

If Table1."Customer No." is relating to the Customer."No." it relates to the PK of table "Customer" - all OK.
But if your Table2."Customer No." should refer to Table1."Customer No." this is only possible if "Customer No." is part of the PK in Table1 ...

Could this be the issue? Could you just relate Table2."Customer No." to Customer."No." instead?
Or did I get it wrong ?!?

vijay_g

hi.....
as far i understand u r question, you have to put simply table name(customer) on the table relation propertey of that field.also check PK of both table.

kriki

[Topic moved from 'SQL General' forum to 'NAV/Navision' forum]

Hanen

Thanks for yours answers,
it was a problem with primary keys, now it works :thumbsup: