Nested relationship ???

[jtwilber]

Order_detail relates to Order_main by Order#. Order_main relates to Customer by Customer# . Order_detail layout shows related Customer# but because it is not directly related to Customer it can not find Customer name. (Customer name in Order_main thru relationship. I know this is simple but I'm lost.

Thanks

[Peter Fenner]

Why can't you create a relationship between Customer Nr in Customer DB and the Customer Nr in Order_Detail?

Pete

PS: I cannot find the hash key on my mac keyboard.

[EddyB]

Peter - Try Alt and 3 - I think - from what I can remember from my Mac days

[Ugo DI LUCA]

L.IT. ?

L.UP ?

[Peter Fenner]

I found it - Shift 3 (which should return the british pound which is Alt 3. But do not forget, apart from this keyboard blimp, Mac is superior in every other way. Mac Users are normally nicer people too (sic)

Pete

[broberts7usa]

I'll go with "Mac users are normally nicer people too", but I won't go with "Mac is superior" (see above) - NO WARS, ok?

Can someone tell me how to type a paragraph symbol with my inferior Windows keyboard?

[Ugo DI LUCA]

jtwilber,

Apart these shortkeys problems, what is it that you cannot relate ?

Order Detail is a layout in the Order_Main file ! So why would you want it to related to the Order_Main file ?

You're not on a Mac, are you ?

[jtwilber]

uh ok... Orderdetail.db5 is a file that holds the line items (item#, description, Quantity, product blurb etc) for an order (related by order#). OrderMain.db5 is the basic order info (Customer#, Customer name, Contact, dates etc.). OrderMain.db5 has a portal that looks up Customer name from Customer.db5 thru Customer# relationship. When I try to create a lookup in orderdetail.db5 from OrderMain.db5 Customername field does not show up in the field list (maybe because it is in a portal and not actually a fixed field. :

PS - I'm not on a mac but I really am nice.... honest.

JWilber

[Ugo DI LUCA]

uh ok... Orderdetail.db5 is a file that holds the line items (item#, description, Quantity, product blurb etc) for an order (related by order#). OrderMain.db5 is the basic order info (Customer#, Customer name, Contact, dates etc.). OrderMain.db5 has a portal that looks up Customer name from Customer.db5 thru Customer# relationship. When I try to create a lookup in orderdetail.db5 from OrderMain.db5 Customername field does not show up in the field list (maybe because it is in a portal and not actually a fixed field. :

Well, Customer_ID and Name should come through a lookup to the Order_Main.

When entering the order in the Line Item, you should use a portal set to create related records.

In the Line Item, the Customer_Id should be filled by lookup to the Order_Main by a relationship Order#::Order#, and the Customer Name could either be a lookup from the Customer file, using Line Item:Customer_ID::Customerfile:Customer_ID or from the Order_Main file using exactly the same relationship Line Item:Customer_ID::OrderMain:Customer_ID

[Pupiweb]

OrderMain.db5 has a portal that looks up Customer name from Customer.db5 thru Customer# relationship.

This doesn't make much sense, and makes me think/guess that you've only define a CustomerID field in Orders by which yo see the related Customer record in Customers; however you haven't probably defined a CustomerName field in Orders and hence you cannot lookup this info in OderDetails, in which you must have passed the customerID using a lookup from Orders

So you can either

Create customer fields in Orders and lookup data in OrderDetails from Orders or - probably better - lookup up customer data in OrderDetails directly from Customers

HTH