|
-
Oct 6th, 2000, 12:51 AM
#3
Thread Starter
Lively Member
How about this?
Can I create a DB named Customers.mdb, then put a "Customer table with tables that contain information that is the same no matter what the location, such as office phone and so on. Then have a "Location" table that would have location specific information such as equipment number, location name and so on. I want the location information in a ListView and customer name and what ever else in that table can be in text boxes. Then write a routine to load textboxes( Select CustName, OfficePhone From Customer) and a routine to load the listview(Select EquipmentNumber, LocationName, customer From Location Where customer = txtCustName.Text) Not this actual code but just to get the idea across. If I load the textboxes first, can I use the current customer displayed and use txtCustName to get all locations that have a matching customer name field. I doubt anyone can understand this, I've confused myself now. Would this be a repeating group?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|