I have been using the following convention for field naming in tables:

TRANSACTION.DBF

tr_id I(4)
tr_code C(10)
tr_dtime DATETIME
tr_exported L(1)
tr_cl_id I(4) (FK from client table)
tr_pr_id I(4) (FK form products table)


CLIENT.DBF
cl_id I(4)
cl_name C(30)
cl_address1 C(30)

etc.

PRODUCTS.DBF
pr_id I(10)
pr_name C(30)
etc.

I have used FKeys as in the transaction table above so that one can easily know where the join is.

Any comments on this naming scheme. I have been told that this is an OLD method and that the "NEW" thinking is to use :

TRANSACTION
id I(4)
code c(10)
productid I(4)
clientid I(4)
exported L(1)

CLIENT
id I(4)
name C(30)


PRODUCT
id I(4)
name C(30)
etc.

Comments and thoughts please.

Bernard