Hi All,

I'm developing a form with a cost subform. One problem, this subform may only contain 0NE record(this record has more than 10 fields on it)
Is there a way this can be done ?

Greetz from Belgium

Stan

Hi Stan,

If there can only be one record, is it worth including those fields with the parent record? Or, if you link your subform to the primary key of you main form, then as long as the table that is linked to your subform only contains a single record for each record in the main form, then you should be OK.

Mike

Mike
EchoVue.com

This option don't seem to work, I've always getting a error message !!
Do you know if a work-around is available ?

Hi Stanny,

Can you give more info, as Mike's suggestion works for me.

Best wishes,

Clive Astley

I've used a workaround and put all the 10 cost fields in the Primary table, of course this works fine, I only hope this give no slower performance

Thx for your assistance

Stan

If you do see that it is affecting your performance, try and just add a field like Cost_FK to your primary table, and then create a Cost table with Cost_PK and the 10 required fields. Set the recordsource of the subform to the Cost table and set the bound property of the subform to Cost_FK. The value in Cost_FK should corrospond to the value in Cost_PK.



Mike
EchoVue.com