Getting details as opposed to PK (id)

[lazysheepmedia]

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

 

[Sophist]

In a dbJoin you set both the value (which is stored in the database) and the Label (which is what is displayed to the user) - typically you would use e.g. the property id as value and property address as label.