On Apr 3, 2011, at 12:10 PM, John Fabiani wrote:
> Thanks that helped. And in the customer record the FK 33 would be saved for
> future transactions.
That's backwards from the way data is usually designed: customers can
have multiple addresses (i.e., cust 1:M address). Address has a FK to customer;
there is usually logic and/or additional columns to indicate active/inactive;
preferred/main; etc., but that isn't part of the problem.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
