Master/Detail issue with linked tables

M

Michael Sainz

Hi all,
Have an issue with a master/detail control...or any control really that
has a link to a linked table. I have a SQL server as the main connection and
the main table is called Customers. Under Customers is a linked table called
ShippingAddress. It is linked via a field called CustomerID. What i'm trying
to do here is lookup customers billing addresses in the table called
Customers and then lookup ShippingAddress via the linked table called
ShippingAddresses. Simple eh?

Well...I have done some fooling around and I cannot get the
master/detail to populate when the ShippingAddress table is linked to the
Customers table. If it is in a fourm all by itself, then it will lookup data
just fine. But when together, I get no love here.

Is there a limitation of the control that i'm not familiar with? I don't
see anything and would think this is possable, but any help is much
appreciated!

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Master/Detail :: Invalid Context Issue 1
Retrieving Value in a table field via link to another table 1
Master/Detail DataSet delete cascade error 0
How can an XML file be used in a master-detail relationship? 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
SQL Data Connection to multiple tables 0
Issue with hidden field in Pivot table 1
Form & Subforms 1

Top