With a view in your database!
Cheers,
Henner
hi:
i have a problem when use dbform, i have two
tables, one is ODS_CIRCUIT, another is ODS_CUSTOMER, there's a field called
CUSTOMERID in ODS_CIRCUIT which references the field in ODS_CUSTOMER called
ID, when i show the table of ODS_CIRCUIT, i want to show the customer's
name ( a field in table ODS_CUSTOMER) instead of the
CUSTOMERID, but none of them is the key, so how to do , how to reference
the customer's name by customerid?
thanks!
|