Thanks for that, Pavle.
> I found a small bug in it. It doesn't work if you use spaces in your
> TO names (which we use a lot). I am not talking leading spaces
> (which I am not using but rather spaces inside the name).
> It shows everything fine until the first space in the TO names, but
> after the first space shows random results.
>
> Eg. I name my tables as A_name, B_name etc
> I name my main TO as A_Name, inner related TOs as "A to B to
> D_blabla", and external db TOs as "A to xA to xF_blabla"
I never use spaces in anything, table names, TO names, value lists,
custom functions, or fields, or anything else. This comes from many
years of programming BFM (Before FileMaker), when spaces in names was
just not allowed, and it seems to me to be pretty good practice. All
my names are made up of compound capitalised words.
In TOs, I always name them like this:
the base table is always called tXxxxxx, where the 't' stands for
'table'.
The TOs based on the above table would always be called Xxxxxx_Yyyyyy,
where tYyyyyy is the name of the base table it is relating to.
For instance, to pick one at random, I have a TO in the current
solution called
'ClientDept_ClientContact_Job_All
@FindByJobTitleList_DisplayByAccount'. From its name I can tell
exactly what tables it relates, and how. Sometimes the TO name
elements have a 'g' suffix, which means 'global'.
Without such a naming convention, in a solution of over 400 TOs (from
an original 43 base tables), I would never know where I was!
I'm sure other naming conventions are available!
Colm
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
