same field names for bound controls

scratch

Registered User.
Local time
Yesterday, 16:39
Joined
May 10, 2005
Messages
98
is there any problem with fields in differnent tables that have a field name that's the same? My concern is the control source for a bound control. Access can keep track of this if a few of these similar field names are on the same form and bound?

scratch
 
Would this apply to renaming a pk as an fk in another as well? An example:

Customer Order Returns 'tables
CustmerID fkOrderCustomerID fkReturnsCustmerID

I personally like leaving the pk the same in all the tables that it's an fk in - it's just a lot easier to read and understand table relations. Unless access may screw up referencing the right one, I'k like to leave the pk as fk names alone. What's the best way to go?
 

Users who are viewing this thread

Back
Top Bottom