Designer Questions

Guys,

What is the best way to setup folders when we have two entities in one = table (ie customer and reseller are in one table and are related by a = related table?

Ismail.


Listserv Archives (BOB member since 2002-06-25)

I don’t know that there is one BEST way. You could use database views to separate customers from resellers, then Designer treats them as two separate tables. Or in Designer you could set up aliases to separate them, making sure you use conditions in your object definitions to identify if it is a customer or a reseller.


Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

What is the best way to setup folders when we have two entities in one table (ie customer and reseller are in one table and are related by a related table?


Listserv Archives (BOB member since 2002-06-25)