You are essentially wanting a "select * from Procedure"?
/dev/mrg
On 2/4/07, Frank Rocco <farocc..otmail.com> wrote:
>
> Hello,
>
> I need to display a table that shows all procedures with a column that says
> if there is a schedule for the current date and what provider is assigned.
>
> Procedure Table
> procedure_id (PK)
> procedure_name
>
> Provider Table
> provider_id (PK)
> provider_name
>
> Schedule Table
> schedule_id (PK)
> schedule_date
> procedure_id (FK)
> provider_id (FK)
>
> I need to display all procedures regardless if there is a record in the
> provider or procedure table.
> Before Cayenne, I was using JDBC to build a List of records that I asssigned
> to a Click Table.
>
> I am trying to redo this in Cayenne.
> Am I on the right track or does Cayenne allow me to redesign this?
>
> Regards,
>
> Frank Rocco
> farocc..otmail.com
>
>
>
This archive was generated by hypermail 2.0.0 : Sun Feb 04 2007 - 18:05:19 EST