[superdan]

Hi all

 

i have 2 tables:

 

--------------------------------------------------------------------------

Company

id  companyname note (which is a varchar in a editor field)

-------------------------------------------------------------------------

Appointments

id  idcompany  date

--------------------------------------------------------------------------

 

company are in relation with appointemnts 1_n: a company can have multiple appointments

 

Ok, now would like to view / edit / update / insert the 'note' field from any appointment i create, and edit and this field must be always the same: the Company table field 'note'

 

is it this possible?

Thanks so much for your answer

 

p.s. whan i insert a NEW appointment i must see old notes inserted before and i can edit them

[Paul Savostin]

So why u dont use custom field when insert or edit Appointments? In that field u could get value from related company record and with callback function update old value!

[superdan]

can you gine me the right syntax for this case please? Thanks!

[Paul Savostin]

can you gine me the right syntax for this case please? Thanks!

U think i will write code for u? I can just give u the right idea, cause if i give the code u'll dont learn anything:)

If u have more concrete questions i will be glad answer to u:)

Just try to write some code and show where u have the problem