lazysheepmedia
Member
Folks
Can someone please help me on this one
I have a form which allows a user to record rent received and this gathers info from the tenancy table via dbjoins and cdd elements
I then have a form which allows a user to create a statement but I am having a problem with the dbjoins and cdd's
When I save the rent received form, it adds the primary key (pk), which is the id in this case, to the table. So when I want to choose the property via a rent statement form it displays the pk and the address and this has the knock on effect of having the cdd's displaying the id's
To see what I mean check this screen-cast to get an idea of what I have.
http://screencast.com/t/MgRBriDP
I am guessing that I need to somehow join the tenancy table and the property table so that the property address is saved into the rent table as well as the id?
Thanks
Can someone please help me on this one
I have a form which allows a user to record rent received and this gathers info from the tenancy table via dbjoins and cdd elements
I then have a form which allows a user to create a statement but I am having a problem with the dbjoins and cdd's
When I save the rent received form, it adds the primary key (pk), which is the id in this case, to the table. So when I want to choose the property via a rent statement form it displays the pk and the address and this has the knock on effect of having the cdd's displaying the id's
To see what I mean check this screen-cast to get an idea of what I have.
http://screencast.com/t/MgRBriDP
I am guessing that I need to somehow join the tenancy table and the property table so that the property address is saved into the rent table as well as the id?
Thanks