My situation is this, I have a table named Job (jobId set to be an
identity value). It records something else that's useful, but I have
it simplified for this post.
I also a table call JobVoid, that stores the datetime when the job is
being voided (voidDateTime), by a Staff. So, a Job is void
http://docs.transfer-orm.com/wiki/Using_Composite_Keys.cfm
http://docs.transfer-orm.com/wiki/Transfer_Configuration_File.cfm
For examples:
http://docs.transfer-orm.com/wiki/Example_Code.cfm#tPetmarket
Mark
On Mon, Feb 2, 2009 at 7:55 PM, henry henryho...@gmail.com wrote:
My situation is
If you make it a OneToMany in JobVoid then you'd be able to
interrogate it from Job using hasParentJobVoid().
Bob
On Mon, Feb 2, 2009 at 4:48 AM, henry henryho...@gmail.com wrote:
Thank you for your prompt response, but...
This is not a case of composite Keys, 'cause VoidJob only has one ID
Thank you for your prompt response, but...
This is not a case of composite Keys, 'cause VoidJob only has one ID
to Job, staffID is not a key.
I have read Transfer_Configuration_File.cfm, but it does not say
anything about *identity ID column cannot be used in manytoone on the
same table*.