I am creating an application which is using VB.NET. On the form I have two listboxes. The one listbox is bound to a master table in Access 2000 (MasterBldg). The second listbox is bound to a selection table (SelBldg) which is related to a client table via a primary/foreign key relationship. I am trying to generate SQL to show the results of moving Bldgs selected from the MasterBldg listbox to the SelBldg listbox. I have the SQL working for the SelBldg listbox. The tables are designed in Access 2000 as follows:
Client Table
PK - CustID
ClientName
Address
City
State
Zip
MasterBldg Table
PK - BldgID
Bldg
SelBldg Table
PK - BldID
FK -CustID
Building
There is probably a simple solution to this using just the Client Table and the SelBldg table, where the entire MasterBldg listbox can be a query of the SelBldg table since it contains all Client Bldgs by CustID rather than having a separate MasterBldg table and a SelBldg table. Any help would be appreciatd on this, Thanks in advance.
Al
Client Table
PK - CustID
ClientName
Address
City
State
Zip
MasterBldg Table
PK - BldgID
Bldg
SelBldg Table
PK - BldID
FK -CustID
Building
There is probably a simple solution to this using just the Client Table and the SelBldg table, where the entire MasterBldg listbox can be a query of the SelBldg table since it contains all Client Bldgs by CustID rather than having a separate MasterBldg table and a SelBldg table. Any help would be appreciatd on this, Thanks in advance.
Al
